-- 修改权限;
-- 在'C:\ProgramData\MySQL\MySQL Server 8.0\my.ini'文件中修改
-- secure-file-priv = ""
MySQLworkbench中导出文件:
use hrs;
select * from tb_emp into outfile 'D:/code/mysql_files/emp.txt';
select * from tb_emp into outfile 'D:/code/mysql_files/emp.csv'
fields terminated by ',' -- 分隔
enclosed by '""' -- 值用什么包裹
lines terminated by '\n'; -- 使用什么换行