如何从MySQL数据查询创建XML文件? [英] How to create an XML file from MySQL Data queries?

问题描述

我想知道一种仅使用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 ?

更新:

我想清除这个问题，我想使用sql查询，它将XML数据转发到php脚本.

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

推荐答案

此处为这是有关写作的帖子MySQL查询文件的结果:

SELECT whatever FROM whereever
INTO OUTFILE '/path/to/file.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

结合这两种技术，应该可以在不编写脚本的情况下创建XML文件.

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

这篇关于如何从MySQL数据查询创建XML文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！