To import your csv data to Mysql table, which can be achieved by using load data in MySQL
Here a file will be created (here i have created tbltest.csv file) in C. tbltest is my table in Mysql
load data infile 'C:\\tbltest.csv' into table tbltest fields terminated by ',' enclosed by '"' lines terminated by '\r\n';