自己写SQL语句
LOAD DATA LOCAL INFILE 'C:\\Users\\sy\\Desktop\\work\\testdata\\LV52_T_TDW.DAT'
INTO TABLE cloudbill_notice
CHARACTER SET GBK
FIELDS TERMINATED BY '|/001'
LINES TERMINATED BY '\n'
因为分隔符是|[] 这鬼东西 ,直接用 ‘|’分割也可以
自己写SQL语句
LOAD DATA LOCAL INFILE 'C:\\Users\\sy\\Desktop\\work\\testdata\\LV52_T_TDW.DAT'
INTO TABLE cloudbill_notice
CHARACTER SET GBK
FIELDS TERMINATED BY '|/001'
LINES TERMINATED BY '\n'
因为分隔符是|[] 这鬼东西 ,直接用 ‘|’分割也可以