I’ve written an article highlighting some recent developments with XML support in MySQL 5.1 and MySQL 6.0. Topics include:
- Outputting MySQL data in XML format; includes a look at the 3rd-party lib_mysqludf_xql library
- Getting XML into MySQL; includes a discussion of the LOAD XML statement (new in MySQL 6.0)
- The ExtractValue() and UpdateXML() functions (new in MySQL 5.1)
- Security issues, including a look at a little nasty known as “XPath injection”
You can read it at the MySQL Developer Zone.
Alexander Barkov contributed a nifty stored procedure and a very helpful pre-publication review. Thanks, Bar!