CODEWITHSUNDEEP
mysqlcsv
Nick_Core
Nick_Core

Reputation: 136

LOAD simple CSV file MySQL

Trying to load a .csv this simple:

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

Into a table with 2 fields 

id       int(11) primary
values   varchar(255)

like this:

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

LINES TERMINATED BY '\n'
IGNORE 1 LINES

but when i load it, I get something like 

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

as if it didn't understand the linebreak rule \n

pulling my hair off already. what am I doind wrong?

in other words, what is the correct query for loading this file?

Upvotes: 0

Views: 63

Answers (1)

Zafar Malik
Zafar Malik

Reputation: 6854

Try below one-

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;

Upvotes: 1

Related Questions