mysql LOAD DATA does not parse correctly

Question

I have a csv file with four columns. Structure of this file is as shown below.

"Id","Title","Content","Author" "1","......","..............","..." "2",".............","....................","......"

The command below

 LOAD DATA LOCAL INFILE '/data/trn.csv' INTO TABLE TR_DATA FIELDS TERMINATED BY ',' ENCLOSED BY '"' IGNORE 1 LINES ;

does not parse correctly and puts wrong inputs to fields. How can I parse correctly?

Need more information to answer this question. What do you mean my 'puts wrong inputs to fields'. What is the structure of TR_DATA. What is actually inserted into it when you run above query. — dhavald
– dhavald, Commented Sep 25, 2013 at 14:39

eggyal · Accepted Answer · 2013-09-25 14:48:45Z

1

As documented under LOAD DATA INFILE Syntax:

Note

If you have generated the text file on a Windows system, you might have to use LINES TERMINATED BY '\r\n' to read the file properly, because Windows programs typically use two characters as a line terminator. Some programs, such as WordPad, might use \r as a line terminator when writing files. To read such files, use LINES TERMINATED BY '\r'.

answered Sep 25, 2013 at 14:48

eggyal

127k18 gold badges220 silver badges244 bronze badges

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

Collectives™ on Stack Overflow

mysql LOAD DATA does not parse correctly

1 Answer 1

Note

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Note

Comments

Your Answer

Sign up or log in

Post as a guest

Related