snippetsmania.com
Post and share your code snippets

LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE `locations` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '' LINES TERMINATED BY ' r n'

source