SET GLOBAL local_infile=1;

LOAD DATA LOCAL INFILE 'test.csv' INTO TABLE dbname.tabname
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 LINES
(col1, col2, col3, col4, col5...);