mysql——某表所有记录的导出和导入——csv文件

1select * from cr01
2into outfile 'C:/Users/del/Desktop/table1_data.csv'
3character set gb2312
4fields terminated by ',' optionally enclosed by '"' escaped by '"'
5lines terminated by '\r\n'
6
7select * from cr01;
8delete  from cr01;
9
10load data infile 'C:/Users/del/Desktop/table1_data.csv'
11into table cr01 character set gb2312
12fields terminated by ',' optionally enclosed by '"' escaped by '"'
13lines terminated by '\r\n';