LOAD DATA
CHARACTERSET UTF8
infile 'Path of data file'
APPEND
INTO TABLE 'Table name' FIELDS TERMINATED BY 
TRAILING NULLCOLS
(
PBKEY,
WRE_ID,
STATE_ABBR,
FIPSCODE,
WRE_CLS,
WRE_MODEL,
RISKDESC,
RISK_LEVEL,
SEVERITY,
FREQUENCY,
COMMUNITY,
DAMAGE,
MITIGATION,
URBAN_CONF,
INTENSITY,
CROWN_FIRE,
WIND_SPD,
EMBER_CAST,
BURN_PROB,
HIST_PERIM,
PROB_IGNIT,
LINE_DIST,
STRUCTURE,
W_ALIGN_RD,
ACC_EGRESS,
VEG_COVER,
HIST_LOSS,
I_AND_D,
F_STN_DIST,
WATER_DIST,
TOPO_POS,
BURNABLE,
STR_THREAT,
H2H_THREAT,
FPOBJECTID,
FPACRES,
FPAGENCY,
FPYEAR,
FPFIRENAME,
FPDATE,
DISTHIGH,
DISTVH,
DISTEXT
)