1.导出表到CSV文件方法
select * from table_name
into outfile 'C:/ProgramData/MySQL/MySQL Server 5.7/xx.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
2.出现错误 [Err] 1290 - The MySQL server is running with the --secure-file-priv option so it cannot execute this statement解决办法
出现这个错误的原因是mysql没有对修改本地文件的权限,除非修改权限。
但是,mys对'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/‘是有权限的,
所以把导出目录改为'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/xx.csv即可。
对于windows7,默认是隐藏ProgramData文件夹的。解决办法是:
1.打开c盘后,点击“组织”
找到“文件夹与搜索选项”
然后选择“查看”,选择“显示隐藏的文件夹及文件,驱动器",然后点击”应用“,”保存“;