uploading csv file into mysql

[Chrisio]

Hi
As the subject says really, where do i start in uploading a csv file so i can run an insert against my db. I really have zero ideas about this so all the help you guys can give me will be brill

Cheers
Chrisio

[visualAd]

It is possible, you need to use a LOAD DATA INFILE query. The following query will load a windows CSV file into your database:

LOAD DATA INFILE 'c:\\path\\to\\file.csv' INTO TABLE tbl_name
    FIELDS TERMINATED BY ',' 
    OPTIONALLY ENCLOSED BY '"'
    LINES TERMINATED BY '\r\n';