Re: MySQL import of XML

Whatever PointedEars ment to say - I did some search & replace and ended up with a file where all lines began with "<text" like

<text number="2">
<text top="164" left="450" width="47" height="10">02MAR15</text>
....
</text>

Then a quick table:
CREATE TABLE clist (

     number INT,
     line INT,
     top INT,
     left INT,
     width INT,
     height INT,
     text VARCHAR(80)

and

LOAD XML LOCAL INFILE
'/home/me/xml/ManualCheckList_MOD_9.xml' INTO TABLE clist ROWS IDENTIFIED BY '<text>';

Query OK, 10788 rows affected (0,33 sec) Records: 10788 Deleted: 0 Skipped: 0 Warnings: 0

Have a nice week-end! Received on Sat Jul 18 2015 - 23:21:17 CEST