上一个复制键在触发后如何给出何处条件

Question

下面的代码是我用Navicat为Mysql编写的触发器。插入部分工作正常，但更新我需要更新基于id的特定行数量。如何在update sql查询中编写where子句

insert into closingstockt(CLS_BSID,CLS_Qty,CLS_SQty,CLS_CDate)
select BS_ID as CLS_BSID,BS_Qty as CLS_Qty,BSS_Qty as CLS_SQty,curdate() 
from barstockt
where CLS_BSID=BS_ID 
on duplicate key update CLS_Qty=BS_Qty,CLS_SQty=BSS_Qty

Answer 1

ON DUPLICATE KEY UPDATE将更新数据库中已经存在的行。例如:

INSERT INTO table (field,field2) VALUES ('data1','data2')
ON DUPLICATE KEY UPDATE lastupdate=NOW()

编辑:我建议使用IF()

插入……ON DUPLICATE KEY UPDATE with WHERE?