mysql - 不将数据从csv文件检索到mysql

Question

我想将csv文件导入到mysql中。我正在使用以下代码:

LOAD DATA local INFILE 'D:\20507.csv' 
INTO TABLE rohit1
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS

但是它不起作用；它只显示第一列记录？帮我出去。

Answer 1

试试这个:

LOAD DATA local INFILE 'D:/20507.csv' INTO TABLE rohit1 FIELDS TERMINATED
BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;