uploading csv file into mysql

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
:wave:

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

Code:

---

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

---