Answers

Question and Answer:

  Home  MySQL Programming

⟩ How To Return Query Output in XML Format?

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 mysqlin

>mysql -u root -X test

mysql> 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)

 138 views

More Questions for you: