mysql LOAD DATA INFILE not working

Question

I am trying to use mysql LOAD DATA INFILE on command line to load csv file. It neither gives any error nor it loads any data. Can anyone please help me out? I am using following command

mysql> LOAD DATA INFILE '/Applications/XAMPP/xamppfiles/htdocs/dev/__php__/mysql/data.csv'
->             INTO TABLE csvdata
->               FIELDS TERMINATED BY ','
->               OPTIONALLY ENCLOSED BY '"'
->               LINES TERMINATED BY '\n'
->               IGNORE 1 LINES;
Query OK, 0 rows affected (0.00 sec)
Records: 0  Deleted: 0  Skipped: 0  Warnings: 0

Following is my CSV file

"emp_id","first_name","last_name","username"
"EMP1","Tibass","Deloris","Tibass1"

Regards

Are you sure about the line feed in your csv? Try the \r\n or \r instead of the \n — Cristian Porta
– Cristian Porta, Commented Nov 4, 2013 at 6:20
I have answered your question, if you want to close... for the posterity ;) — Cristian Porta
– Cristian Porta, Commented Nov 28, 2013 at 6:10

Cristian Porta · Accepted Answer · 2013-11-28 06:07:38Z

8

Probably your file line terminator differs from your definition in the LOAD DATA statement.

Try the \r\n or \r instead of the \n.

answered Nov 28, 2013 at 6:07

Cristian Porta

4,4433 gold badges21 silver badges26 bronze badges

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

Collectives™ on Stack Overflow

mysql LOAD DATA INFILE not working

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