How to export xml from a mysql database

D: \ mysql-5.1.26-rc-win32 \ bin> mysql-X-utest test-e "select * from t1;" | tee f: \ out. xml
Copy codeThe Code is 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: xml format
-Utest (specify the user name and database, and there is no password here)
"Select * from t1;" specifies the SQL statement to be executed. Do not forget the semicolon.
| Tee f: \ out. xml (tee is used here for output orientation, because my machine has the mkt tools toolbox,
Therefore, Unix commands can be used in the same way. If you are not used to them, you can directly use> to direct them to f: \ out. xml, that is, mysql-X-utest test-e "select * from t1;"> f: \ out. xml