How to create an XML file from MySQL data queries?

advertisements

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.


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.