mysql批量插入数据唯一索引判断解决

Posted by LeoSpring on May 29, 2019
   insert into supplier_company_employ_relation (companyId, supplierId,name,idcard) values
        (52837,25,'王五','HGHGGJ785955'),(52837,25,'李四','HJKJG78595'),(52837,25,'张三','HJKJG78595')
        
        ON DUPLICATE KEY UPDATE
        companyId=VALUES(companyId),supplierId=VALUES(supplierId),name=VALUES(name),idcard=VALUES(idcard)