Organizational Research By

Surprising Reserch Topic

How will you export tables as an XML file in MySQL?



asked Sep 13, 2013 in MYSQL by rajesh
edited Sep 12, 2013
0 votes
11 views



Related Hot Questions

1 Answer

0 votes
From the command prompt type the following statement:
 
mysql -u test --xml -e 'SELECT * FROM t1' > t1.xml
 
where ‘ –u test ‘ is the user name, --xml indicates the type of the file is xml, -e for export
 
answered Sep 13, 2013 by rajesh
edited Sep 12, 2013

...