MySQL XML表导出命令行 [英] Mysql XML table export command line

问题描述

也许我在这里看不到任何东西，但是为什么在LINUX命令行上运行时，此命令行可以正常工作并提供结果集，但是从WINDOWS命令行执行时，它却无法正常运行并且什么也不返回?

Maybe I'm not seeing something here but WHY would this command line work perfectly fine and provide a result set when run on a LINUX command line but when executed from a WINDOWS command line it fails dismally and returns nothing?

mysql -hHOSTNAME -uroot -p --xml -e 'SELECT * FROM db.table' > c:\temp\output.xml

我在这里想念什么?

推荐答案

Windows命令行无法将'识别为引号字符，因此您的语句参数变为SELECT(在第一个空格处被截断).

Windows command line does not recognize ' as a quote character, so your statement parameter becomes SELECT (truncated at the 1st space).

您必须改用"，如Heena Hussain所建议.

You must use " instead, as Heena Hussain suggested.

这篇关于MySQL XML表导出命令行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！