How to get xml output for a query

[Amit Jhingran]

How can we get output from a query as xml, I tried using --xml options but not able to use it.

I alos tried to use the query
select Concat('<row>\n',
Concat(' <id>', id, '</id>\n'),
Concat(' <fname>', fname, '</fname>\n'),
'</row>') as xmldoc from user;

But the problem with this query is that the I don't get any root tag for the xml output. Please help


Thanks
Amit Jhingran