mysql - 加载简单的 CSV 文件 MySQL

Question

尝试如此简单地加载 .csv:

"Id";"Values"
"1";"Value1"
"2";"Value2"
...
...
"n";"Valuen"

进入有 2 个字段的表

id       int(11) primary
values   varchar(255)

像这样:

LOAD DATA LOCAL INFILE 'file_name.csv'
REPLACE
INTO TABLE tbl_name
FIELDS
    TERMINATED BY ';'
    ENCLOSED BY '"'

LINES TERMINATED BY '\n'
IGNORE 1 LINES

但是当我加载它时，我得到类似的东西

+----+--------------+
| id | value        | 
+----+--------------+
|  1 | value1" "2   | 
|  2 | value3" "4   |
|  3 | value5" "6   |
|  4 | value7" "8   |
|  5 | value9" "10  | 
|  6 | value11" "12 | 
+----+--------------+

就好像它不理解换行规则\n

已经把我的头发扯下来了。我做错了什么？

换句话说，加载此文件的正确查询是什么？

Answer 1

尝试下面的一个-

LOAD DATA LOCAL INFILE 'file_name.csv' REPLACE INTO TABLE tbl_name FIELDS ESCAPED BY '\\' TERMINATED BY ';' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES;