MySQL Programming Question:
Download Questions PDF

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">
<field name="id">1</field>
<field name="name"></field>
<field name="id">10</field>
<field name="name"></field>
2 rows in set (0.00 sec)

Download MySQL Programming Interview Questions And Answers PDF

Previous QuestionNext Question
How To Return Query Output in HTML Format?What Is SQL in MySQL?