MySql deleting rows of csv file

Question

I am trying to upload a csv to a MySql database but the following code is not working. I am entering the query directly into MySql.

Create table testing.test (
test VARCHAR(50),
test2 VARCHAR(50),
primary key (test));

LOAD DATA LOCAL INFILE 'C:/test.csv' 
             INTO TABLE testing.test
             FIELDS 
                TERMINATED BY ','
             LINES TERMINATED BY '\r\n';

Basically it deletes all rows but the final row of the table. It produces the following message: "7 row(s) affected Records: 8 deleted: 0 Skipped". Any ideas why the rows are being deleted?

I would assume that your line break encoding does not match that of the csv file. — arkascha
– arkascha, Commented Jun 5, 2017 at 18:35

arkascha · Accepted Answer · 2017-06-05 18:52:45Z

1

Posting my comment to the question as answer for others:

I would assume that your line break encoding does not match that of the csv file. That can result in lines getting skipped, since they do not match the described format. Only the last line will get accepted in such scenario, since for that no terminating line break is required.

answered Jun 5, 2017 at 18:52

arkascha

43.2k8 gold badges61 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySql deleting rows of csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related