how do i import data from a csv file to my mysql database

[cmills83]

i tried like a million things and im ready to murder someone, can someone walk me through it? thanks.

[MitkOK]

MySQL commands :

You can then import it into a MySQL table by running:

load data local infile 'file.csv' into table table
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
(field1, field2, field3)

The fields here are the actual tblUniq table fields that the data needs to sit in. The enclosed by and lines terminated by are optional and can help if you have columns enclosed with double-quotes such as Excel exports, etc.

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

WIth PHP :

Look in the attached file.

- Mitko Kostov

[MitkOK]

Double post, please delete it.