一个正确的mysql触发器,你能看出错误吗?

来源:互联网 发布:好听的网络歌曲大全 编辑:程序博客网 时间:2024/04/29 10:38

DELIMITER $$
CREATE
    TRIGGER details_insert AFTER INSERT
    ON jeecg_details
    FOR EACH ROW BEGIN         
          SET @newspent = NEW.SPENT;
          SET @newprojectid = NEW.projectid;
          UPDATE jeecg_project SET totalspent = totalspent + newspent WHERE projectid = newprojectid;
          UPDATE jeecg_project SET tptalamount = tptalamount - newspent WHERE projectid = newprojectid;
    END$$

DELIMITER ;

删除MYSQL触发器:

DROP TRIGGER details_insert;

查看MYSQL触发器:

SELECT * FROM information_schema.TRIGGERS

原创粉丝点击