不规则数据加载

-- 建表
create table tcplx (a int, b varchar(100), c datetime, d datetime  );

-- 加载
LOAD DATA INFILE 'file://10.158.4.66//opt/data/tcplx.txt' INTO TABLE test.tcplx DATA_FORMAT 3 FIELDS TERMINATED BY '#$%^&' table_fields 'a, b, c date "%H:%i:%s %Y-%m-%d", d ' autofill FIELDS ENCLOSED BY '\xFF' LINES TERMINATED BY '\x80'  null_value '%nu$ll%'  character set gbk  ignore 3 lines   ;