Wednesday, January 27, 2010

Exporting mysql query output to xml

I know there are ways to do this. But wasn't aware that it is very simple.
Exporting mysql query output to xml is:
mysql -u --xml -e''

Simple, isn't it?

Reference:http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.0.html#xml-5.1-in-and-out

This article also talks about importing data from xml to mysql.

No comments: