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, 2312🔥, 0💬
Popular Posts:
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with e...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...