select * from cr01
into outfile ‘C:/Users/del/Desktop/table1_data.csv‘
character set gb2312
fields terminated by ‘,‘ optionally enclosed by ‘"‘ escaped by ‘"‘
lines terminated by ‘rn‘


select * from cr01;
delete  from cr01;



load data infile ‘C:/Users/del/Desktop/table1_data.csv‘
into table cr01 character set gb2312
fields terminated by ‘,‘ optionally enclosed by ‘"‘ escaped by ‘"‘
lines terminated by ‘rn‘;