--新增触发器
drop trigger if exists test_zwd;
delimiter//
create trigger test_zwd
after insert on platformbackstage.t_oper_keywords_copy
for each row
begin
insert into baseForReptile.t_oper_keywords_copy(id,columnId,platFormIds,name,note,`order`,isUsed,createUserId,lastModifyUserId,createTime,lastModifyTime)
values(new.id,new.columnId,new.platFormIds,new.name,new.note,new.`order`,new.isUsed,new.createUserId,new.lastModifyUserId,new.createTime,new.lastModifyTime);
end;
//
delimiter;
--删除触发器
drop trigger if exists test_zwd_delete;
delimiter//
create trigger test_zwd_delete
after delete on platformbackstage.t_oper_keywords_copy
for each row
begin
delete from baseForReptile.t_oper_keywords_copy where id = old.id;
end;
//
delimiter;
--修改的触发器
drop trigger if exists test_zwd_update;
delimiter//
create
trigger test_zwd_update
before update
on platformbackstage.t_oper_keywords_copy
for each row
begin
update baseForReptile.t_oper_keywords_copy set id=new.id,columnId=new.columnId,platFormIds=new.platFormIds,name=new.name,note=new.note,`order`=new.`order`,isUsed=new.isUsed,createUserId=new.createUserId,lastModifyUserId=new.lastModifyUserId,createTime=new.createTime,lastModifyTime=new.lastModifyTime where id = old.id;
end;
//
delimiter;