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

1导出文本文件：
2select sx,mz,bz from cr01 into OUTFILE 'C:/Users/del/Desktop/a.txt'
3fields terminated by ':' LINES TERMINATED BY '\r\n';
4
5
6
7
8导入恢复：
9
10load data infile 'C:/Users/del/Desktop/a.txt' into table cr01
11FIELDS TERMINATED BY ':'
12LINES TERMINATED BY '\r\n';

前期数据准备：

导出数据：

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

删除数据：

导入数据：

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

验证查询：