MYSQL对单表的导入导出

导入

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 设置导入的字符集，不然导入中文会为乱码