MySQL SELECT INTO OUTFILE 导出选项
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9140879/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
MySQL SELECT INTO OUTFILE Export options
提问by georgepsarakis
Does anyone know where can I find the documentation for all the export options of the SELECT ... OUTFILE statement of MySQL? I have noticed in multiple questions parameters such as
有谁知道我在哪里可以找到 MySQL 的 SELECT ... OUTFILE 语句的所有导出选项的文档？我在多个问题中注意到参数，例如
FIELDS ENCLOSED BY delimiter
FIELDS ESCAPED BY delimiter
FIELDS TERMINATED BY delimiter
but I haven't managed to find the complete list of parameters yet. Can somebody please help?
但我还没有找到完整的参数列表。有人可以帮忙吗？
回答by Mosty Mostacho
This is the official documentation.
这是官方文档。
You might want to take a look at thistoo, as it seems the syntax from [FIELDS] and [LINES] is taken from the "load data infile"
您可能也想看看这个，因为 [FIELDS] 和 [LINES] 的语法似乎取自“加载数据输入文件”
