load data

LOAD DATA INFILE 'D:GX\mm.txt' REPLACE INTO TABLE mm FIELDS TERMINATED BY ' '

// 以空格为分隔符插入数据,前提是mm.txt字段顺序要和表mm字段顺序一致,Navicat测试通过

原文地址:https://www.cnblogs.com/playforever/p/7928006.html