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, 1815🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...