load data local infile ,importing csv to mysql table not working properly

Question

I am using load data infile to import data from csv to mysql table, but data is not inserted properly,

in the csv file fields are enclosed by ", e.g. "field1","field2","field3" some fields consist of multiple lines..

here is my script..

load data local infile 'my.csv' into table mytable fields terminated by ',' enclosed by '"' lines terminated by '\n'

please help

Devart · Accepted Answer · 2011-10-14 10:39:33Z

2

I have tried on MySQL 5.5, it works, even if some fields consist of multiple lines.

Try to use '\r\n' as a line separator.

answered Oct 14, 2011 at 10:39

Devart

120k23 gold badges172 silver badges189 bronze badges

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

1 Answer 1