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

Question

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.

Answer 1

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