top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

0 votes
362 views
How will you export tables as an XML file in MySQL?
posted Jul 1, 2014 by Deepak Negi

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

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

answer Jul 3, 2014 by Devyani
Similar Questions
0 votes

How can I insert data into one table from two other tables where i have three tables namely users, role and userrole.
Now I want to insert the data into userrole table from users table and role table with a single statement.

...