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;
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;