By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise:>cd mysql in>mysql -u root -X testmysql> SELECT * FROM links;<?xml version="1.0"?><resultset statement="SELECT * FROM links"> <row> <field name="id">1</field> <field name="name">www.GlobalGuideLine.com</field> </row> <row> <field name="id">10</field> <field name="name">www.GlobalGuideLine.com</field> </row></resultset>2 rows in set (0.00 sec)
By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise:>cd mysql in>mysql -u root -X testmysql> SELECT * FROM links;<?xml version="1.0"?><resultset statement="SELECT * FROM links"> <row> <field name="id">1</field> <field name="name">www.GlobalGuideLine.com</field> </row> <row> <field name="id">10</field> <field name="name">www.GlobalGuideLine.com</field> </row></resultset>2 rows in set (0.00 sec)
Comments Received:
Please give your suggestions and feedback: