mysql夸库触发器

mysql夸库触发器

-- `assets3.0`为操作的数据库名称，assets_status为操作数据库的表，`assets_yanshi`为触发器要操作的数据库名称，new.id 这些是操作的数据库的值-- 插入触发器DROP TRIGGER IF EXISTS assets_status_insert;CREATE TRIGGER assets_status_insert AFTER INSERT ON `assets3.0`.assets_statusFOR EACH ROWBEGIN     insert into `assets_yanshi`.assets_status(id,name,sort,type) values(new.id,new.name,new.sort,new.type);END;

-- 修改触发器drop trigger if exists assets_status_update;create trigger assets_status_update before update on `assets3.0`.assets_status for each row begin update `assets_yanshi`.assets_status set id=new.id,name=new.name,sort=new.sort,type=new.type where id = old.id; end;

 -- 删除触发器drop trigger if exists assets_status_delete;create trigger assets_status_delete after delete on `assets3.0`.assets_statusfor each rowbegin  delete from `assets_yanshi`.assets_status where id = old.id;end;