LOAD DATA CHARACTERSET UTF8 infile '' APPEND INTO TABLE FIELDS TERMINATED BY "|" TRAILING NULLCOLS ( code, ge_whtpopcy, ge_blkpopcy, ge_indpopcy, ge_asnpopcy, ge_hpipopcy, ge_othpopcy, ge_twopopcy, ge_hsppopcy, ge_nhpopcy, ge_nhp1whtcy, ge_nhp2blkcy, ge_nhp3indcy, ge_nhp4asncy, ge_nhp5hpicy, ge_nhp6othcy, ge_nhp7twocy, ge_hsp1whtcy, ge_hsp2blkcy, ge_hsp3indcy, ge_hsp4asncy, ge_hsp5hpicy, ge_hsp6othcy, ge_hsp7twocy, ge_p0004cy, ge_p0509cy, ge_p1014cy, ge_p1519cy, ge_p2024cy, ge_p2529cy, ge_p3034cy, ge_p3539cy, ge_p4044cy, ge_p4549cy, ge_p5054cy, ge_p5559cy, ge_p6064cy, ge_p6569cy, ge_p7074cy, ge_p7579cy, ge_p8084cy, ge_p85pcy, ge_pmedcy, ge_padultcy, ge_pamedcy, ge_p1819cy, ge_malecy, ge_m0004cy, ge_m0509cy, ge_m1014cy, ge_m1519cy, ge_m2024cy, ge_m2529cy, ge_m3034cy, ge_m3539cy, ge_m4044cy, ge_m4549cy, ge_m5054cy, ge_m5559cy, ge_m6064cy, ge_m6569cy, ge_m7074cy, ge_m7579cy, ge_m8084cy, ge_m85pcy, ge_mmedcy, ge_madultcy, ge_mamedcy, ge_m1819cy, ge_femalecy, ge_f0004cy, ge_f0509cy, ge_f1014cy, ge_f1519cy, ge_f2024cy, ge_f2529cy, ge_f3034cy, ge_f3539cy, ge_f4044cy, ge_f4549cy, ge_f5054cy, ge_f5559cy, ge_f6064cy, ge_f6569cy, ge_f7074cy, ge_f7579cy, ge_f8084cy, ge_f85pcy, ge_fmedcy, ge_fadultcy, ge_famedcy, ge_f1819cy, ge_avghhszcy, ge_gqpopcy, ge_hhs1percy, ge_hhs2percy, ge_hhs3percy, ge_hhs4percy, ge_hhs5percy, ge_hhs6percy, ge_hhs7percy, ge_ls02englcy, ge_ls03spancy, ge_ls04frhccy, ge_ls05gowgcy, ge_ls06rposcy, ge_ls07oieucy, ge_ls08korecy, ge_ls09chincy, ge_ls10vietcy, ge_ls11tagacy, ge_ls12oapicy, ge_ls13arabcy, ge_ls14otuncy, ge_an01amercy, ge_an02arabcy, ge_an03britcy, ge_an04czeccy, ge_an05danicy, ge_an06dutccy, ge_an07englcy, ge_an08eurocy, ge_an09frency, ge_an10frcncy, ge_an11germcy, ge_an12greecy, ge_an13hungcy, ge_an14iriscy, ge_an15italcy, ge_an16lithcy, ge_an17norwcy, ge_an18policy, ge_an19portcy, ge_an20russcy, ge_an21scircy, ge_an22scotcy, ge_an23slovcy, ge_an24safrcy, ge_an25swedcy, ge_an26swiscy, ge_an27ukracy, ge_an28welscy, ge_an29windcy, ge_an30othgcy, ge_an31ucnrcy )