How to convert query resutls to XML

You can display SQL query results in XML format when running mysql from command line:

$ c:/mysql/bin/mysql -u [user_name] -p [database_name] -X -e "SELECT * FROM
forums_phpbb_config"
Enter password: ******
<?xml version="1.0"?>

<resultset statement="SELECT * FROM forums_phpbb_config
">
  <row>
        <config_name>config_id</config_name>
        <config_value>1</config_value>
  </row>

  <row>
        <config_name>board_disable</config_name>
        <config_value>0</config_value>
  </row>

  <row>
        <config_name>sitename</config_name>
        <config_value>yourdomain.com</config_value>
  </row>
...
  <row>
        <config_name>split_sticky</config_name>
        <config_value>1</config_value>
  </row>
</resultset>