MySQL creating and populating the database

Question

Hi,
I have downloaded the MySQL 5.2.5.1 version. I need to create the database and populate it. O have the data file in .csv format. I'm running the Mysql on windows. So when I create the database and a table in it, I want to populate the data from a file on my PC which is in .csv format.
I did it in this way:

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

But it is not working for me. Where I am making a mistake?

Answer 1

You might need to change

lines terminated by '\n'

to

lines terminated by '\r\n'