How to create an XML file from MySQL Data queries?

mysql, xml

Solution

Here's a blog post about returning XML from MySQL SELECT queries:

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

And here's a post about writing the results of a MySQL query to a file:

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.

Problem

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.

Original source