导出文本文件： 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‘;
验证查询：
mysql——导入文本文件——用load data infile命令
原文：https://www.cnblogs.com/xiaobaibailongma/p/12109459.html