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;