The realization method of XML in Mysql database _mysql

D:\mysql-5.1.26-rc-win32\bin>mysql-x-utest test-e "select * from T1;" | Tee F:\out.xml

Copy Code code as follows:

<?xml version= "1.0"?>

<resultset statement= "SELECT * from T1" xmlns:xsi= "Http://www.w3.org/2001/XMLSchema-instance" >
<row>
<field name= "id" >1</field>
</row>

<row>
<field name= "id" >2</field>
</row>
</resultset>

-x specified as XML format
-utest Test (specify username and database, no password here)
"SELECT * from T1;" To specify the SQL statement to execute, do not forget the semicolon
| Tee f:\out.xml (I used tee, output orientation, because my machine has MKT tools toolbox,
So UNIX commands can be used, not accustomed to, you can directly use > to direct to F:\out.xml, that is, mysql-x-utest test-e "select * from T1;" > F:\out.xml