Producing XML Output from MySQL

Producing XML Output from MySQL

1.25.1 Problem
You'd like to turn a query result into XML.

1.25.2 Solution
mysql can do that for you.

1.25.3 Discussion
mysql creates an XML document from the result of a query if you use the -X (or --xml) option.