in case this helps, this is for the year 2010 data create table visa_status (

LCA_CASE_NUMBER text, STATUS text, LCA_CASE_SUBMIT text, VISA_CLASS text, LCA_CASE_EMPLOYMENT_START_DATE text, LCA_CASE_EMPLOYMENT_END_DATE text, LCA_CASE_EMPLOYER_NAME text,

LCA_CASE_EMPLOYER_ADDRESS text,

LCA_CASE_EMPLOYER_CITY text,

LCA_CASE_EMPLOYER_STATE text,

LCA_CASE_EMPLOYER_POSTAL_CODE text,

LCA_CASE_SOC_CODE text,

LCA_CASE_SOC_NAME text,

LCA_CASE_JOB_TITLE text,

LCA_CASE_WAGE_RATE_FROM text,

LCA_CASE_WAGE_RATE_TO text,

LCA_CASE_WAGE_RATE_UNIT text,

FULL_TIME_POS text,

TOTAL_WORKERS text,

LCA_CASE_WORKLOC1_CITY text,

LCA_CASE_WORKLOC1_STATE text,

PW_1 text,

PW_UNIT_1 text,

PW_SOURCE_1 text,

OTHER_WAGE_SOURCE_1 text,

YR_SOURCE_PUB_1 text,

LCA_CASE_WORKLOC2_CITY text,

LCA_CASE_WORKLOC2_STATE text,

PW_2 text,

PW_UNIT_2 text,

PW_SOURCE_2 text,

OTHER_WAGE_SOURCE_2 text,

YR_SOURCE_PUB_2 text,

LCA_CASE_NAICS_CODE text,

Decision_Date text);

LOAD DATA LOCAL INFILE '/H1B_2010_TEXT/H1B_FY2010.txt' INTO TABLE visa_status FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';