MySQL如何导入csv格式数据文件解决方案

load data infile 'D://top-1m.csv'
into table `site`
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '/n';

select * from `site`
into outfile 'D://top-1m.csv'
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '/n';