Re: XML 2 MYSQL

[Jonathan Stephens]

For MySQL 5.0, you'll have to write some kind of parser application to turn the XML into INSERT statements.

For MySQL 5.1, the job might be much simpler using the XML/XPath functions that have been added in that version.

See in particular the ExtractValue() function http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html#function_extractvalue, which now supports variables in XPath expressions.

Jon Stephens
MySQL Documentation Team @ Oracle

MySQL Dev Zone
MySQL Server Documentation
Oracle