Optionally Enclosed By ""

gistfile1.sql

create schema nj_teacher_salaries;
create table nj_teacher_salaries.salaries (
last_name TEXT,
first_name TEXT,
county TEXT,
district TEXT,
school TEXT,
primary_job TEXT,
fte TEXT,
salary TEXT,
certificate TEXT,
subcategory TEXT,
teaching_route TEXT,
highly_qualified TEXT,
experience_district TEXT,
experience_nj TEXT,
experience_total TEXT);
LOAD DATA INFILE '/Users/Justin/Developer/mysql/data_files/nj_teachers_salaries_cls.csv'
INTO TABLE nj_teacher_salaries.salaries
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
OPTIONALLY ENCLOSED BY ""
IGNORE 1 ROWS
(last_name, first_name, county, district, school, primary_job, fte, salary, certificate, subcategory, teaching_route, highly_qualified, experience_district, experience_nj, experience_total);