您可以使用mysql LOAD DATA INFILE命令完成此任务。
首先创建表：

CREATE TABLE items (
    field1 ...,
    field2 ...,
    field3 ...
    PRIMARY KEY (field1)
);

然后执行以下命令：

LOAD DATA INFILE 'data.csv' # full path to the csv file
INTO TABLE items         
FIELDS TERMINATED BY ','    # adjust to your csv format
ENCLOSED BY '"'             # adjust to your csv format
LINES TERMINATED BY '\n'    # adjust to your csv format
IGNORE 1 ROWS;              # if you have header row in the csv

还可以指定文件中的列与表中的列之间的Map，甚至可以更改。
例如，假设您要Map：

[column1 in table] is [column3 in csv]
[column2 in table] is [column5 in csv]
[column3 in table] is [column1 in csv]
[column4 in table] is 2 * [column6 in csv]
[column5 in table] is the current timestamp
ignore [column2 in csv]
ignore [column4 in csv]

您可以使用以下命令：

LOAD DATA INFILE 'data.csv' # full path to the csv file
INTO TABLE items
FIELDS TERMINATED BY ','    # adjust to your csv format
ENCLOSED BY '"'             # adjust to your csv format
LINES TERMINATED BY '\n'    # adjust to your csv format
IGNORE 1 ROWS.              # if you have header row in the csv
(column3, @skip, column1, @skip, column2, @c4)
SET 
  column4= 2*@c4, 
  column5=CURRENT_TIMESTAMP;