Import CSV file in Mysql Database

Copy your csv file in following folder.

C:\Program Files\MySQL\MySQL Server 5.0\bin.

run following command:

LOAD DATA Local INFILE "export_vnflsch_1.csv" INTO TABLE YourTable FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY """" LINES TERMINATED BY "\r\n";

http://www.visli.com/