MySQL LOAD DATA INFILE import / export
Example
import
SELECT a,b,c INTO OUTFILE 'result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM table;
Export
LOAD DATA INFILE 'result.txt' INTO TABLE table;
import
SELECT a,b,c INTO OUTFILE 'result.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM table;
Export
LOAD DATA INFILE 'result.txt' INTO TABLE table;
