>我有一个包含五列(id,姓名,年龄,数字,电子邮件)的表格,其中(列"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 'rn' (@dummy,@dummy,number,@dummy);
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 'rn'
(`number`);