How to create an XML file from MySQL Data queries?

Question

Hello

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.

Answer 1

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.

Answer 2

You can do it quite easily from the command prompt, see this:

http://blog.reindel.com/2007/09/27/output-mysql-query-results-to-xml-from-the-command-prompt/