mysql –xml and some XSLT

Somebody asked in Freenode the other day how to get their data out of MySQL into a specific XML format.

Both mysqldump and the mysql client have –xml options. The output from the cli looks like this:

via A Little Noise » Blog Archive » mysql’s –xml and some XSLT.