触发器当一个表插入数据,另一个表的Bonus+100
CREATE OR REPLACE TRIGGER tri_bonus
after insert
ON client_info
FOR EACH ROW
BEGIN
update manger_sal set bonus=bonus+100 where mid=:new.mid;
END tri_bonus;
CREATE OR REPLACE TRIGGER tri_bonus
after insert
ON client_info
FOR EACH ROW
BEGIN
update manger_sal set bonus=bonus+100 where mid=:new.mid;
END tri_bonus;