导出文本文件:
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';
验证查询: