How to Use the MySQL command line to export data in XML format

The following describes how to use MySQL command lines to export data in XML format using MySQL command lines. If you are interested in MySQL command lines, take a look.

Use the "-X" option.

 
 

  
  
# mysql -X -u root -e "use mysql; select * from user;" 
 
 

The output result is as follows:

 
 

  
  
<?xml version="1.0"?> 
  
  
   
  
  
<resultset statement="select * from user"> 
  
  
  <row> 
  
  
        <field name="Host">localhost</field> 
  
  
        <field name="User">root</field> 
  
  
        <field name="Password"></field> 
  
  
        <field name="Select_priv">Y</field> 
  
  
        <field name="Insert_priv">Y</field> 
  
  
        <field name="Update_priv">Y</field> 
  
  
        <field name="Delete_priv">Y</field> 
  
  
        <field name="Create_priv">Y</field> 
  
  
        <field name="Drop_priv">Y</field> 
  
  
        <field name="Reload_priv">Y</field> 
  
  
        <field name="Shutdown_priv">Y</field> 
  
  
        <field name="Process_priv">Y</field> 
  
  
        <field name="File_priv">Y</field> 
  
  
        <field name="Grant_priv">Y</field> 
  
  
        <field name="References_priv">Y</field> 
  
  
        <field name="Index_priv">Y</field> 
  
  
        <field name="Alter_priv">Y</field> 
  
  
        <field name="Show_db_priv">Y</field> 
  
  
        <field name="Super_priv">Y</field> 
  
  
        <field name="Create_tmp_table_priv">Y</field> 
  
  
        <field name="Lock_tables_priv">Y</field> 
  
  
        <field name="Execute_priv">Y</field> 
  
  
        <field name="Repl_slave_priv">Y</field> 
  
  
        <field name="Repl_client_priv">Y</field> 
  
  
        <field name="Create_view_priv">Y</field> 
  
  
        <field name="Show_view_priv">Y</field> 
  
  
        <field name="Create_routine_priv">Y</field> 
  
  
        <field name="Alter_routine_priv">Y</field> 
  
  
        <field name="Create_user_priv">Y</field> 
  
  
        <field name="ssl_type"></field> 
  
  
        <field name="ssl_cipher"></field> 
  
  
        <field name="x509_issuer"></field> 
  
  
        <field name="x509_subject"></field> 
  
  
        <field name="max_questions">0</field> 
  
  
        <field name="max_updates">0</field> 
  
  
        <field name="max_connections">0</field> 
  
  
        <field name="max_user_connections">0</field> 
  
  
  </row> 
  
  
</resultset> 
 
 

The preceding section describes how to use MySQL command lines to export data in XML format.

Solution to querying garbled characters in MySQL

How to delete duplicate records in MySQL

Use MySQL temporary tables to accelerate queries

How to properly use MySQL Indexes

Automatic Restoration of MySQL Log Files