MySQL触发器
-- 创建BEFORE类型触发器 CREATE TRIGGER SumOfSalary BEFORE INSERT ON tb_emp8 FOR EACH ROW SET @sum=@sum+NEW.salary; -- 触发BEFORE类型触发器 SET @sum=0; INSERT INTO tb_emp8 VALUES(1,'A',1,1000),(2,'B',1,500); -- 创建AFTER类型触发器 CREATE TRIGGER double_salary AFTER INSERT ON tb_emp6 FOR EACH ROW INSERT INTO tb_emp7 VALUES (NEW.id,NEW.name,deptId,2*NEW.salary); -- 触发AFTER类型触发器 INSERT INTO tb_emp6 VALUES (1,'A',1,1000),(2,'B',1,500); -- 删除触发器 DROP TRIGGER double_salary;