LOAD DATA LOCAL INFILE 'mydata.csv'
INTO TABLE mytable
FIELDS
TERMINATED BY ','
ENCLOSED BY '"'
(list, of , your , table, field);