例句:
select * from table_name into outfile '/tmp/tmp.csv' fields terminated by ',';
详解:
① into outfile '/tmp/tmp.csv' 指定导出文件的目录和文件名
② fields terminated by ',' 将数据以逗号“,”隔开
select * from table_name into outfile '/tmp/tmp.csv' fields terminated by ',';
转载于:https://www.cnblogs.com/ExMan/p/9884933.html