mysql——导入文本文件——用load data infile命令

导出文本文件：
select sx,mz,bz from cr01 into OUTFILE 'C:/Users/del/Desktop/a.txt'
fields terminated by ':' LINES TERMINATED BY '\r\n';




导入恢复：

load data infile 'C:/Users/del/Desktop/a.txt' into table cr01
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\r\n';

 

 

 

 

 

 

前期数据准备：

 

 

 

 

导出数据：

select sx,mz,bz from cr01 into OUTFILE 'C:/Users/del/Desktop/a.txt'
fields terminated by ':' LINES TERMINATED BY '\r\n';

 

 

 

 

 

 

 

 

 

 

删除数据：

 

 

 

 

 

 

 

 

 

 

导入数据：

load data infile 'C:/Users/del/Desktop/a.txt' into table cr01
FIELDS TERMINATED BY ':'
LINES TERMINATED BY '\r\n';

 

 

 

 

 

 

 

验证查询：