load data local infile 'x' replace into table ods_emr.sz_dwfl_tmpae72b0638a0566dd0 character set utf8mb4 fields terminated by ',' enclosed by '"' escaped by '"' lines terminated by '\n' (@col1,@col2,@col3,@col4,@col5,@col6,@col7,@col8,@col9,@col10,@col11,@col12,@col13,@col14,@col15,@col16,@col17,@col18,@col19,@col20,@col21,@col22,@col23,@col24,@col25,@col26,@col27,@col28,@col29,@col30,@col31,@col32,@col33,@col34,@col35,@col36,@col37,@col38,@col39,@col40,@col41,@col42,@col43,@col44,@col45,@col46,@col47,@col48,@col49,@col50,@col51,@col52,@col53,@col54,@col55,@col56,@col57,@col58,@col59,@col60,@col61,@col62,@col63,@col64,@col65,@col66,@col67,@col68,@col69,@col70,@col71,@col72,@col73,@col74,@col75,@col76,@col77,@col78,@col79,@col80,@col81,@col82,@col83,@col84,@col85,@col86,@col87,@col88,@col89,@col90,@col91,@col92,@col93,@col94,@col95,@col96,@col97,@col98,@col99,@col100,@col101,@col102,@col103,@col104,@col105,@col106,@col107,@col108,@col109,@col110,@col111,@col112,@col113,@col114,@col115,@col116,@col117,@col118,@col119,@col120,@col121,@col122,@col123,@col124,@col125,@col126,@col127,@col128,@col129,@col130,@col131,@col132,@col133,@col134,@col135,@col136,@col137,@col138,@col139,@col140,@col141,@col142,@col143,@col144,@col145) set SJLY_DM=nullif(@col1,''),SJID=nullif(@col2,''),RHBOOLD=nullif(@col3,''),HMSJRYQ=nullif(@col4,''),LYFS=nullif(@col5,''),CJSJ=nullif(@col6,''),YLJGDM=nullif(@col7,''),BLH=nullif(@col8,''),ZKKB=nullif(@col9,''),BLOODF=nullif(@col10,''),QZJDRSJ=nullif(@col11,''),CLBZ=nullif(@col12,''),DJCZY=nullif(@col13,''),HY=nullif(@col14,''),LXRXM=nullif(@col15,''),XB=nullif(@col16,''),LCWLZLF=nullif(@col17,''),ZYLSH=nullif(@col18,''),SJCPLUS=nullif(@col19,''),JKKH=nullif(@col20,''),RYBF=nullif(@col21,''),JY3=nullif(@col22,''),AGE=nullif(@col23,''),HMSJRYH=nullif(@col24,''),ZRHSXM=nullif(@col25,''),ZYZFY=nullif(@col26,''),YLFFFS=nullif(@col27,''),BH=nullif(@col28,''),XZZ=nullif(@col29,''),LXRDZ=nullif(@col30,''),EMPI=nullif(@col31,''),ZKRQ=nullif(@col32,''),ZZYSGH=nullif(@col33,''),KZRGH=nullif(@col34,''),BZ=nullif(@col35,''),ZYZFJE=nullif(@col36,''),EXT2=nullif(@col37,''),BDBLZPF=nullif(@col38,''),SYSZDF=nullif(@col39,''),BSLX=nullif(@col40,''),REASON4=nullif(@col41,''),CSRQ=nullif(@col42,''),SSYCXCLF=nullif(@col43,''),EMPIPLUS=nullif(@col44,''),BLZDF=nullif(@col45,''),YXYXZDF=nullif(@col46,''),REASON3=nullif(@col47,''),CYSJ=nullif(@col48,''),SDI_SYS_COLLECT_TIME=nullif(@col49,''),BSHM=nullif(@col50,''),ZRHSGH=nullif(@col51,''),ZDJLXH=nullif(@col52,''),EXT1=nullif(@col53,''),LCZDXMF=nullif(@col54,''),SCBZ=nullif(@col55,''),JY2=nullif(@col56,''),SSZLMZF=nullif(@col57,''),YBYLFWF=nullif(@col58,''),KZRXM=nullif(@col59,''),SXYSXM=nullif(@col60,''),SSZLSSF=nullif(@col61,''),BOOLD=nullif(@col62,''),BAHM=nullif(@col63,''),SSZDWY=nullif(@col64,''),SWHZSJ=nullif(@col65,''),XYF=nullif(@col66,''),CSD=nullif(@col67,''),QTFY=nullif(@col68,''),COUNTRY=nullif(@col69,''),YBZLCZF=nullif(@col70,''),JLXH=nullif(@col71,''),ZLYYCXCLF=nullif(@col72,''),REASON1=nullif(@col73,''),ZYYSGH=nullif(@col74,''),NXYZLZPF=nullif(@col75,''),ZKHSXM=nullif(@col76,''),DH=nullif(@col77,''),ZKHSGH=nullif(@col78,''),YWGM=nullif(@col79,''),KFF=nullif(@col80,''),CYKS=nullif(@col81,''),BLZD=nullif(@col82,''),KJYWFY=nullif(@col83,''),ZKYSGH=nullif(@col84,''),SJZYT=nullif(@col85,''),JG=nullif(@col86,''),XGBZ=nullif(@col87,''),JCYYCXCLF=nullif(@col88,''),SXYSGH=nullif(@col89,''),DWDH=nullif(@col90,''),ZYYSXM=nullif(@col91,''),SLXRGX=nullif(@col92,''),BMYXM=nullif(@col93,''),QTF=nullif(@col94,''),ZRYSXM=nullif(@col95,''),JY4=nullif(@col96,''),CSTZK=nullif(@col97,''),RYSJ=nullif(@col98,''),HLF=nullif(@col99,''),ZRYSGH=nullif(@col100,''),QDBLZPF=nullif(@col101,''),BRXM=nullif(@col102,''),JXYSGH=nullif(@col103,''),BAZL=nullif(@col104,''),ZCEYF=nullif(@col105,''),POSTCODE3=nullif(@col106,''),FKDQDM=nullif(@col107,''),FJ_WSJGDM=nullif(@col108,''),JY1=nullif(@col109,''),SSZLF=nullif(@col110,''),JGDM=nullif(@col111,''),BIRTHDAY=nullif(@col112,''),MJ=nullif(@col113,''),LXRDH=nullif(@col114,''),ZJLX=nullif(@col115,''),ZZYSXM=nullif(@col116,''),RYTJ=nullif(@col117,''),FSSZLXMF=nullif(@col118,''),MONTH=nullif(@col119,''),POSTCODE1=nullif(@col120,''),ZCAYF=nullif(@col121,''),XBYZLZPF=nullif(@col122,''),BMYGH=nullif(@col123,''),WSJGDM=nullif(@col124,''),ZJHM=nullif(@col125,''),ZCZYJH=nullif(@col126,''),SBKH=nullif(@col127,''),SSZDWYBM=nullif(@col128,''),REASON2=nullif(@col129,''),MZ=nullif(@col130,''),HKDZ=nullif(@col131,''),LRSJ=nullif(@col132,''),BLZDJBBM=nullif(@col133,''),SSID=nullif(@col134,''),JXYSXM=nullif(@col135,''),ZY=nullif(@col136,''),POSTCODE2=nullif(@col137,''),SFZHM=nullif(@col138,''),GZDWDZ=nullif(@col139,''),CYBF=nullif(@col140,''),CLRQ=nullif(@col141,''),RYTZK=nullif(@col142,''),ZYZLF=nullif(@col143,''),ZKYSXM=nullif(@col144,''),RYKS=nullif(@col145,'')