导入
load data infile 'e:\a.txt' into table tableA character set utf8 fields terminated by ',' enclosed by '"' lines terminated by '\r\n' ;
导出
select * from tableA into outfile 'e:\a.txt' fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
导入的语句中character set utf8 设置导入的字符集,不然导入中文会为乱码