there are a few ways to to it. here's a solution using load data.
load data local infile '/path/to/csvfile'
fields terminated by ','
enclosed by '"'
lines terminated by '\n'
[ignore 1 lines]
[(column_1, @dummy, column_2,...)]
notes
line 5: t… more »