I know this is probably a simple question but I can't find what I'm after.
I have XML formatted data that I want to import to tables. Is there a tool/syntax for this somewhere?
Many thanks,
Alex
I know this is probably a simple question but I can't find what I'm after.
I have XML formatted data that I want to import to tables. Is there a tool/syntax for this somewhere?
Many thanks,
Alex
That's not as simple as it may seem. HeidiSQL does provides a tool for importing CSV files, and for loading SQL files, but for XML there is just an export tool, not an import tool.
But probably you can compose and fire a LOAD XML LOCAL INFILE 'mydata.xml'
SQL command, as documented here: https://dev.mysql.com/doc/refman/5.5/en/load-xml.html
Please login to leave a reply, or register at first.