MySQL INTO OUTFILE 错误？

Question

只是想知道在 MySQL 中使用它时是否会产生任何错误，例如服务器上没有足够的空间放置文件或权限被拒绝等？谷歌了一下，但找不到太多东西。

Answer 1

简短回答:是

参见:http://dev.mysql.com/doc/refman/5.0/en/select.html

The SELECT ... INTO OUTFILE 'file_name' form of SELECT writes the selected rows to a file. The file is created on the server host, so you must have the FILE privilege to use this syntax. file_name cannot be an existing file, which among other things prevents files such as /etc/passwd and database tables from being destroyed.

当然，如果没有空间，MySQL也会给你一个错误。