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, 1835🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...