mysql - 更新付款状态的触发器

Question

我有这个触发器，我希望它在将 payment_status 插入支付表后更新项目表中的 payment_status。有人可以帮我解决这个问题。下面是我尝试过的。

CREATE TRIGGER `after_insert_payments` AFTER INSERT ON `payments`
 FOR EACH ROW BEGIN
    IF ( EXISTS (
            SELECT 1 FROM projects
            WHERE projects.amount = NEW.amount
         )
    )    
    THEN UPDATE projects WHERE projects.payment_status = NEW.payment_status,
        SET NEW.payment_status = approved;
    END IF;
END

标签： mysqldatabasetriggers