dumping csv file data into db through sql query

i have a .csv file containing a table data.I want to dump the total csv file into db using a query in mysql using column name as key...

rather than doing it manually...like using "insert into" query...

if any other language like php or python program make this work...then also ok..开发者_开发技巧

can some one suggest me....pls

you can do this fairly easily with navicat software. more info here

load data local infile ...

LOAD DATA LOCAL INFILE '/tmp/your_file.csv' INTO TABLE your_table;

You need to ensure the mysql user has enough privileges to perform load