(唯一约束)没有insert,有update
1. insert into in_invoice_certification(id, company_id, ref_company_id, invoice_id, code, number,source)
values (13,"123","123",1231231299999,'0102','99999','check')
on duplicate key update
source = VALUES(source),
invoice_id = VALUES(invoice_id)
2. insert ignore into id_company (唯一约束)没有插入,有不插入
浙公网安备 33010602011771号