mysql主键重复则更新,不重复则插入
方法一:ON DUPLICATE KEY UPDATE语法示例:insert into .... select * from table2......ON DUPLICATE KEY UPDATE.....insert into comm_org (ORGCD,ORGNM,UPORGCD,UPORGNM,ORGLEVEL,CREATEID,CREATENM,CREATETIME,UPDATEID,UPDATENM,UPDATETIME,VALIDSTATUS) select OR
原创
2021-09-15 14:14:06 ·
1189 阅读 ·
0 评论