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

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