Mysql触发器

最新推荐文章于 2025-05-16 15:07:50 发布

weixin_30488085

最新推荐文章于 2025-05-16 15:07:50 发布

阅读量47

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/cloniu/p/6398207.html

delimiter $
drop trigger if exists insert_color $
create trigger insert_color before insert on color for each row
begin
insert into co(cols) values(new.col);
end $
delimiter ;

插入前

delimiter $
drop trigger if exists insert_color $
create trigger insert_color after insert on color for each row
begin
insert into co(cols) values(old.col);
end $
delimiter ;

插入后

delimiter $
drop trigger if exists insert_color $
create trigger insert_color before delete on color for each row
begin
insert into co(cols) values(new.col);
end $
delimiter ;

删除前

delimiter $
drop trigger if exists insert_color $
create trigger insert_color after delete on color for each row
begin
insert into co(cols) values(old.col);
end $
delimiter ;

删除后

delimiter $
drop trigger if exists insert_color $
create trigger insert_color before update on color for each row
begin
insert into co(cols) values(new.col);
end $
delimiter ;

更新前

delimiter $
drop trigger if exists insert_color $
create trigger insert_color after update on color for each row
begin
insert into co(cols) values(old.col);
end $
delimiter ;

更新后

trigger    触发器

delete    删除

before     之前

for each row     对于每一行

old     老的

new     新的

updata    更新

单词

delimiter $ 
-- delimiter 把 ; 改成 $ 结尾
drop trigger if exists insert_loguser $ 
-- 删除触发器 条件：如果存在 
create trigger insert_color after insert on userinfo for each row
-- 创建触发器 name 插入之后 table  每一行 
begin
-- 开始 
insert into loguser(log_user,log_pwd) values(NEW.user_name,NEW.user_pwd);
-- 插入 table(column) 值(NEW.)  
end $
delimiter ;

详解

转载于:https://www.cnblogs.com/cloniu/p/6398207.html