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