Collections:
Returning Query Output in XML Format in MySQL
How To Return Query Output in XML Format in MySQL?
✍: FYIcenter.com
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)
⇒ Introduction to SQL Basics in MySQL
⇐ Returning Query Output in HTML Format in MySQL
2018-04-21, 1825🔥, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...