Probleem

U wilt een query resultaat converteren in xml.

Oplossing

Gebruik mysql parameters.

Voorbeeld

% mysql -e "SELECT * FROM limbs WHERE legs=0" uw_database
+————+——+——+
| thing | legs | arms |
+————+——+——+
| squid | 0 | 10 |
| octopus | 0 | 8 |
| fish | 0 | 0 |
| phonograph | 0 | 1 |
+————+——+——+
% mysql -X -e "SELECT * FROM limbs WHERE legs=0" uw_database
<?xml version="1.0"?>
<resultset statement="SELECT * FROM limbs WHERE legs=0">
<row>
<thing>squid</thing>
<legs>0</legs>
<arms>10</arms>
</row>
<row>
<thing>octopus</thing>
<legs>0</legs>
<arms>8</arms>
</row>
<row>
<thing>fish</thing>
<legs>0</legs>
<arms>0</arms>
</row>
<row>
<thing>phonograph</thing>
<legs>0</legs>
<arms>1</arms>
</row>
</resultset>