Tuesday, December 8, 2009

How will you export tables as an XML file from MYSQL?

How will you export tables as an XML file from MYSQL?

You can export any result set from MySQL Query Browser by right-clicking within the result set and choosing an option from the Export Resultset sub-menu. You can choose to export the result set in CSV XML HTML Microsoft Excel XLS or PLIST formats.
or you can use the command like
./mysql -ujon test --xml -e 'SELECT * FROM ' > .xml

No comments:

Post a Comment

If you are really interested about our blogger, Please Share your opinion here ...

If you Found Any Interviews in your reliable sources, Please Post the information through this Comment and It will be Published in our blogger. help every one to get a Job.