MySQL导入xxx.txt的数据

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