mysql> LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name
    ->           FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
    ->           LINES TERMINATED BY '\n';