MySQL加载文件无效的整数

Question

I am trying to import the following CSV data into a fresh clean table with the below settings. And keep getting two entries added and then warnings. Why is it giving an error? I have changed it from Inno to MyISAM as I thought that might be the issue, but no luck.

16,"Data point 1"
15,"Data point 2"
14,"Point 3a"
13,"Data total"

After running this SQL

LOAD DATA LOCAL INFILE 'C:/Users/Me/CSV.csv' INTO TABLE points FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY ''

I get the following warning

2 row(s) affected, 2 warning(s): 1366 Incorrect integer value: ' 15' for column 'id' at row 2

The table is setup as follows.

id INT(11) Default 0 PK
value VARCHAR(45) Default NULL

Answer 1

Maybe your lines are not actually terminated by , but instead? That would explain the whitespace character in Incorrect integer value: ' 15' – it would just be the .

So try LINES TERMINATED BY ' ' instead.