mysql 创建xml字段,如何从MySQL数据查询创建XML文件？

I would like to know a way to create an XML file using MySQL queries only. without using any scripting language at all.

Are there any books, tutorials on this topic ?

UPDATE:

I would like to clear it out that I want to use sql queries which would forward XML data to a php Script.

解决方案

xml_escape(value) -

replace characters not allowed in xml with the escape sequences

xml_attr(name, value) -

create an xml attribute

xml_tag(tagname, tagvalue, attrs, subtags) -

create a tag

SELECT whatever FROM whereever

INTO OUTFILE '/path/to/file.csv'

FIELDS TERMINATED BY ','

ENCLOSED BY '"'

LINES TERMINATED BY '\n'

Combining these two techniques should let you create an XML file without any scripting.