import cvs through mysql console

Use this command on mysql console

load data LOCAL infile 'C:/test.csv' into table table_name fields terminated by ',' lines terminated by '\n';

Courtesy : How do I import delimited data into MySQL?