Cacher is the code snippet organizer for pro developers

-- Importing from csv to mysql
load data local infile 'd:/file.csv' into table `people` fields terminated by ','
enclosed by '"'
lines terminated by '\r'
(first_name, last_name, company_name, address, city, country, state, zip, phone1, phone2, email, web);