代码
show variables like '%secure%'
select * into outfile 'D:\app11my1test.xls' from t_students ;
-- 查看路径
本地的my.ini配置文件修改此属性
-- 解决乱码
SELECT a.*
INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/mytest3.csv'
CHARACTER SET gbk
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
from eemployee a ;