mysql - 如何将单列csv文件加载到mysql中的特定列

Question

我有一个包含五列 (id,name,age,number,email) 的表格，其中(列 'id' 是 Pk 并且具有 auto_increment)和一个仅包含信息的单列 csv 文件对于“编号”列。如何在 mysql 中加载此文件。

我已经试过了但是没用:

load data local infile 'C:/Users/user/Downloads/dnd_220116.csv'
into table testing FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\r\n' (@dummy,@dummy,number,@dummy); 

Answer 1

LOAD DATA LOCAL 
    INFILE 'C:\\Users\\<user_name>\\Downloads\\dnd_220116.csv'
    INTO TABLE `<database_name>`.`testing` CHARACTER SET 'utf8' 
    FIELDS ESCAPED BY '\\' 
    TERMINATED BY ',' 
    ENCLOSED BY '"' 
    LINES TERMINATED BY '\r\n' 
(`number`);