進出口

匯入

SELECT a,b,c  INTO OUTFILE 'result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM table;

出口

LOAD DATA INFILE 'result.txt' INTO TABLE table;