The MySQL server is running with the --secure-file-priv option so it cannot exec

参考1：

将csv 文件存入mysql 报错The MySQL server is running with the --secure-file-priv option so it cannot execute_tsing_9521的博客-CSDN博客

参考2：

解决“MySQL server is running with the --secure-file-priv option so it cannot execute this statement”问题_椰果奶茶加冰的博客-CSDN博客

select * from fa.fa_category into outfile "D:/phpstudy_pro/WWW/ccccc.txt" fields terminated by '"' lines terminated by '\r\n';

效果如下：

 

 

select * from fa.fa_category into outfile "D:/phpstudy_pro/WWW/ccccc.txt" fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n'; 

效果如下：

 

 其中语法可参考官网 ：MySQL :: MySQL 8.0 Reference Manual :: 13.2.10.1 SELECT ... INTO Statement MySQL :: MySQL 8.0 Reference Manual :: 13.2.7 LOAD DATA Statement