LOAD DATA LOCAL INFILE; FIELDS TERMINATED; LINES TERMINATED; SET
MySQL导入xxx.txt的数据
LOAD DATA LOCAL INFILE 'C:/xxx/xxx.txt' INTO TABLE table_name CHARACTER SET utf8 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field_name1, field_name2)
SET field_name3 = field_value3,
field_name4 = field_value4;
- FIELDS TERMINATED BY ',':字段间的分隔符
- LINES TERMINATED BY '\n':每条数据的分隔符
导入大量txt时可配合脚本按格式生成sql