mysql loadfile 快速导入导出数据
select * from visits where month(created_at)=6 into outfile 'f:\\visits.txt' fields terminated by ',';

?

?

2..txt文件导入数据

load data infile 'f:\\visits.txt' into table visits fields terminated by ','

?

?