报错信息
Can't create/write to file '/Users/xuran/Downloads/temp.csv' (Errcode: 2 "No such file or directory"), Time: 0.036000s
sql语句
SELECT * FROM `20110711` INTO OUTFILE '/Users/xuran/Downloads/temp.csv'
系统是Mac OS ,Navicat Premium的版本是15
报错信息
Can't create/write to file '/Users/xuran/Downloads/temp.csv' (Errcode: 2 "No such file or directory"), Time: 0.036000s
sql语句
SELECT * FROM `20110711` INTO OUTFILE '/Users/xuran/Downloads/temp.csv'
系统是Mac OS ,Navicat Premium的版本是15
先执行命令show global variables like '%secure_file_priv%';
,确认服务器允许你将文件导出到哪个目录。