LOAD DATA LOCAL导入速度比insert快的多得多
//红色字体处是文件所在位置,绿色字体是表名,橙色是指定字段,FIELDS TERMINATED BY 后面是文件中分割数据的符号,我用的是逗号,例1是所有字段导入,按数据表字段顺序导入,例2是只导入指定字段
例子1:LOAD DATA LOCAL INFILE 'C:\\Users\\abc\\Desktop\\data.txt' INTO TABLEt1 FIELDS TERMINATED BY ',';
例子2:LOAD DATA LOCAL INFILE ' C:\\Users\\abc\\Desktop\\data.txt' INTO TABLE t1 FIELDS TERMINATED BY '.' ( `name`);