触发器 增删改
CREATE TRIGGER t_afterInsert
AFTER INSERT ON bank_infoFOR 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;
END;