LOAD DATA CHARACTERSET UTF8 infile '' APPEND INTO TABLE FIELDS TERMINATED BY "|" TRAILING NULLCOLS ( code, ge_ms02pnmcy, ge_ms03pmarcy, ge_ms04psepcy, ge_ms05pwidcy, ge_ms06pdivcy, ge_ms08mnmcy, ge_ms09mmarcy, ge_ms10msepcy, ge_ms11mwidcy, ge_ms12mdivcy, ge_ms14fnmcy, ge_ms15fmarcy, ge_ms16fsepcy, ge_ms17fwidcy, ge_ms18fdivcy, ge_wrknahcy, ge_wrkahcy, ge_mt01dacy, ge_mt02cpcy, ge_mt03buscy, ge_mt04subcy, ge_mt05railcy, ge_mt06stccy, ge_mt07boatcy, ge_mt08taxicy, ge_mt09mccy, ge_mt10bikecy, ge_mt11walkcy, ge_mt12othcy, ge_tt0004cy, ge_tt0509cy, ge_tt1014cy, ge_tt1519cy, ge_tt2024cy, ge_tt2529cy, ge_tt3034cy, ge_tt3539cy, ge_tt4044cy, ge_tt4559cy, ge_tt6089cy, ge_tt90pcy, ge_ttavgcy, ge_tl0000cy, ge_tl0500cy, ge_tl0530cy, ge_tl0600cy, ge_tl0630cy, ge_tl0700cy, ge_tl0730cy, ge_tl0800cy, ge_tl0830cy, ge_tl0900cy, ge_tl1000cy, ge_tl1100cy, ge_tl1200cy, ge_tl1600cy, ge_se2nspscy, ge_se3kindcy, ge_se4gr14cy, ge_se5gr58cy, ge_se6gr912cy, ge_se7ugradcy, ge_se8gradcy, ge_se9notency, ge_ed02nsccy, ge_ed03grn4cy, ge_ed04gr56cy, ge_ed05gr78cy, ge_ed06gr9cy, ge_ed07gr10cy, ge_ed08gr11cy, ge_ed09gr12cy, ge_ed10hschcy, ge_ed11sc1cy, ge_ed12sc1pcy, ge_ed13assocy, ge_ed14bachcy, ge_ed15mastcy, ge_ed16profcy, ge_ed17doctcy, ge_es2lfcy, ge_es3clfcy, ge_es4clfecy, ge_es5clfucy, ge_es6afcy, ge_es7nlfcy, ge_in01agrcy, ge_in02cnstcy, ge_in03mfgcy, ge_in04wtrdcy, ge_in05rtrdcy, ge_in06trancy, ge_in07infocy, ge_in08firecy, ge_in09profcy, ge_in10educcy, ge_in11artscy, ge_in12othscy, ge_in13publcy, ge_oc01mgntcy, ge_oc02bfopcy, ge_oc03compcy, ge_oc04archcy, ge_oc05lifecy, ge_oc06csscy, ge_oc07leglcy, ge_oc08etlcy, ge_oc09artscy, ge_oc10hltdcy, ge_oc11hlttcy, ge_oc12hltscy, ge_oc13firecy, ge_oc14lawcy, ge_oc15foodcy, ge_oc16bldgcy, ge_oc17perscy, ge_oc18salecy, ge_oc19admncy, ge_oc20farmcy, ge_oc21cnstcy, ge_oc22instcy, ge_oc23prodcy, ge_oc24trancy, ge_oc25matlcy, ge_oc26wccy, ge_oc27bccy )