3 导出XML数据
示例5:以XML形式导出表person_table中的数据
>mysql --xml -e "select info from school.person_table" -uroot -p > person-dump.xml
得到的person-dump.xml内容如下:
1 <?xml version="1.0"?>
2 <resultset statement="select info from school.person_table
3 " xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
4 <row>
5 <field name="info"><person><id_card>111</id_card><name>张三三
6 </name><phone>81891233</phone><phone>81893333</phone></person></field>
7 </row>
8 <row>
9 <field name="info"><person><id_card>444</id_card><name>李四
10 </name><phone>81891233</phone><phone>81893333</phone></person></field>
11 </row>
12 </resultset>
2 <resultset statement="select info from school.person_table
3 " xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
4 <row>
5 <field name="info"><person><id_card>111</id_card><name>张三三
6 </name><phone>81891233</phone><phone>81893333</phone></person></field>
7 </row>
8 <row>
9 <field name="info"><person><id_card>444</id_card><name>李四
10 </name><phone>81891233</phone><phone>81893333</phone></person></field>
11 </row>
12 </resultset>