MySQL: Blank row in table after LOAD DATA INFILE
- by Tom
Hi,
I'm uploading a large amount of data from a CSV (I'm doing it via MySQL Workbench):
LOAD DATA INFILE 'C:/development/mydoc.csv' INTO TABLE mydatabase.mytable CHARACTER SET utf8
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r';
However, I'm noticing that it keeps adding an empty line full of nulls/zeros after the…