mysql导出csv
查看mysqlmysql设置的权限,可以使用
show variables like '%secure%';查看 secure-file-priv 路径是什么
SELECT * INTO OUTFILE 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/demo.csv'
FIELDS TERMINATED BY ','
FROM (select 'id','name' union select*from demo) demo_;