mysql で xml を出力できる

mysql> select * from sample;
+----+--------------+------+
| id | url          | desc |
+----+--------------+------+
|  9 | http://foo/  | foo  |
| 10 | http://bar/  | bar  |
| 11 | http://null/ | NULL |
+----+--------------+------+
3 rows in set (0.01 sec)

% mysql -u root -p --xml
mysql> select * from sample;
<?xml version="1.0"?>

<resultset statement="select * from sample;">
  <row>
        <field name="id">9</field>
        <field name="url">http://foo/</field>
        <field name="desc">foo</field>
  </row>

  <row>
        <field name="id">10</field>
        <field name="url">http://bar/</field>
        <field name="desc">bar</field>
  </row>
  <row>
        <field name="id">11</field>
        <field name="url">http://null/</field>
        <field name="desc" xsi:nil="true" />
  </row>
</resultset>
3 rows in set (0.00 sec)