My So-Called Blog

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 3^rd-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!