mysql导出表的数据，在导入

1.导出　　也可以跟where条件 SELECT * FROM tablename where ...... INTO OUTFILE 'E:accessdetail.txt';

SELECT * FROM tablename INTO OUTFILE 'E:accessdetail.txt';

2.导入

LOAD DATA LOCAL INFILE 'E:accessdetail.txt' INTO TABLE tablename;