Re: MySQL import of XML

Bjarne Jensen wrote:

> On 18.07.2015 19:57, Thomas 'PointedEars' Lahn wrote:
> > The LOAD XML statement does _not_ import *arbitrary* XML into an MySQL
> > database.
> >
> > RTFM: <http://dev.mysql.com/doc/refman/5.6/en/load-xml.html>
>
> ... not a word about arbitrary XML on that page.

Of course not. Read again.

> Do you mean that the XML is "malformed" ?

It is malformed insofar as that MySQL expects a different document tree, which you can see in the examples. Presumably, if you told MySQL that a “page” element means a row, and a “text” element means a column, it could work.

-- 
PointedEars

Twitter: _at_PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.