----------------------------导出
select a,b,c,d FROM tbname where id=50 into outfile "a.txt"
FIELDS
TERMINATED BY '@'
OPTIONALLY
ENCLOSED BY '"'
LINES
TERMINATED BY '\n'
----------------------------插入
load data local infile "c:/a.txt" into table tbname
FIELDS
TERMINATED BY '@'
OPTIONALLY
ENCLOSED BY '"'
LINES
TERMINATED BY '\n'
(a,b,c,d);