导出例子:
select *from test
into outfile 'D:test.csv'
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '
';
导入例子:
load data infile 'D:test.csv'
into table `test`
fields terminated by ',' optionally enclosed by '"' escaped by '"'
lines terminated by '
' ignore 1 lines;
实际操作中根据这个修改就行,有问题的地方还望指教~~