mysql——某表所有记录的导出和导入——csv文件
文章目录
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 '\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';

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论