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
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.