mysql5.7导出到csv

版本：mysql5.7

SELECT * FROM table_name where xxx into outfile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/table_name.csv' fields terminated by ','
optionally enclosed by '"' lines terminated by '\r\n';

fields terminated by ‘字段间分隔符’ #定义字段间的分隔符
optionally enclosed by ‘字段包围符’ #定义包围字段的字符（数值型字段无效）
lines terminated by ‘行间分隔符’ #定义每行的分隔符

遇到的问题：
Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
问题解决方案一：
1、SHOW VARIABLES LIKE "secure_file_priv"; #查看导入导出的目录权限
# secure_file_priv=C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\ #我的查询结果
# secure_file_prive=null # 限制mysqld 不允许导入导出
# secure_file_priv=dir # 限制mysqld的导入导出只能发生在dir目录下
# secure_file_priv='' # 不对mysqld 的导入 导出做限制
2、把要导出的文件存储目录改为 secure_file_priv 指定的目录。
问题解决方案二：修改 “secure_file_priv” 的值。【未实践】

转载于:https://www.cnblogs.com/yuwentims/p/9566794.html