摘要： 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; 阅读全文