MYSQL触发器——增删改

 

 

 

AFTER INSERT ON bank_info
FOR EACH ROW
BEGIN
     insert into test1(id,bank_code,bank_name) values(new.id,new.bank_code,new.bank_name);
END;

CREATE TRIGGER t_afterDelete
After DELETE ON bank_info
FOR EACH ROW
BEGIN
delete from test1 WHERE id=old.id;          
END;

CREATE TRIGGER t_afteUpdate
After UPDATE ON bank_info
FOR EACH ROW
BEGIN
UPDATE test1 SET bank_code=new.bank_code,bank_name=new.bank_name  WHERE id=new.id;     //此处new和old都可以
END;