mysql - 如何在触发器中添加条件？

Question

我有关于crete触发器的查询:

CREATE TRIGGER `Insert` AFTER INSERT ON `HistoryBalance`
 FOR EACH ROW INSERT INTO Winners (name) VALUES  (new.ProductID)

但现在我想获取条件:

if (new.Status = 'user'){
   CREATE TRIGGER `Insert` AFTER INSERT ON `Balance`
 FOR EACH ROW INSERT INTO Winners (name) VALUES  (new.ProductID)
}

请告诉我 crete 触发器如何适合我的情况？

Answer 1

你可以这样做:

delimiter $$
CREATE TRIGGER balance_insert AFTER INSERT ON Balance
    FOR EACH ROW
BEGIN
    if (new.Status = 'user') then
        INSERT INTO Winners(name) VALUES  (new.ProductID);
    end if;
END; $$
delimiter ;

您可以阅读更多Here