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