Returning Query Output in XML Format in MySQL

Q

How To Return Query Output in XML Format in MySQL?

✍: FYIcenter.com

A

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\bin
>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">dba.fyicenter.com</field>
  </row>
  <row>
        <field name="id">10</field>
        <field name="name">dba.fyicenter.com</field>
  </row>
</resultset>
2 rows in set (0.00 sec)

 

⇒Command-Line End User Interface 'mysql'

⇒⇒MySQL Database Tutorials

2018-04-21, 371👍, 0💬

General MySQL Oracle SQL Server