MySQL具有 LOAD DATA INFILE 语法：

MySQL has the LOAD DATA INFILE syntax:

LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
 FIELDS TERMINATED BY ',' ENCLOSED BY '"'
 LINES TERMINATED BY '\r\n'
 IGNORE 1 LINES;

请参阅有关自定义数据处理的文档。

See the documentation about custom data handling.