|
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'; |