(唯一约束)没有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    (唯一约束)没有插入,有不插入

 

 

posted on 2018-01-23 18:53  111-211  阅读(136)  评论(0)    收藏  举报

导航