mysql——某表所有记录的导出和导入——csv文件
时间:2021-07-01 10:21:17
帮助过:3人阅读
* 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 ‘\r\n‘
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 ‘\r\n‘;

mysql——某表所有记录的导出和导入——csv文件
标签:ble use users close from style des code let