load csv into mysql

LOAD DATA LOCAL INFILE ‘/var/tmp/foo.csv’ INTO TABLE foo FIELDS TERMINATED BY ‘,’ ENCLOSED by ‘”‘ LINES TERMINATED BY ‘\n’;