MySQL SELECT INTO OUTFILE 导出选项
有谁知道在哪里可以找到 MySQL 的 SELECT ... OUTFILE 语句的所有导出选项的文档? 我在多个问题中注意到了参数,例如
FIELDS ENCLOSED BY delimiter
FIELDS ESCAPED BY delimiter
FIELDS TERMINATED BY delimiter
,但我还没有找到完整的参数列表。 有人可以帮忙吗?
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
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?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
这是官方文档。
您可能也想看看这个,因为 [FIELDS] 和 [LINES] 中的语法似乎取自“加载数据文件”
This is the official documentation.
You might want to take a look at this too, as it seems the syntax from [FIELDS] and [LINES] is taken from the "load data infile"