MySQL Admin - How To Return Query Output in XML Format
Interview Question Database For Software Developers
|
|
| How To Return Query Output in XML Format | | How To Return Query Output in XML Format? - MySQL FAQs - Command-Line End User Interface mysql | | By: 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)
| | ID: 928 | Rank: 1057 | Votes: 0 | Views: 28 | Submitted: 20070510 |
1060
:-) | | What Is MySQL | | What Is MySQL? - MySQL FAQs - Database Basics and Terminologies... | | Submitted: 20070510 |
|
1051
:-) | | What Is mSQL | | What Is mSQL? - MySQL FAQs - Database Basics and Terminologies... | | Submitted: 20070510 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view