LOAD DATA LOCAL INFILE 'importfile.csv' 
INTO TABLE _test_table_
FIELDS TERMINATED BY ',' 
LINES TERMINATED BY '\n' 
(field1, filed2, field3);