load csv into mysql

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

Leave a Reply

Your email address will not be published. Required fields are marked *