sqlserver2008基础编程2—触发器

最新推荐文章于 2024-04-13 10:36:56 发布

原创最新推荐文章于 2024-04-13 10:36:56 发布 · 560 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

8 篇文章

订阅专栏

本文介绍了一个数据库触发器的实现方案，包括用户添加、删除及更新时的触发逻辑。通过这些触发器可以自动维护点击记录和限制信息，并更新相关联表中的用户名。

-- 触发器 添加用户时触发
create trigger tri_add
after insert on users 
for each row
BEGIN
	insert into click values (null,new.u_id,1,0);
	insert into limits values (null,new.u_id,1,0);
END
 -- drop TRIGGER tri_add;
 
-- 触发器 删除用户时触发
create trigger tri_del
after DELETE on users 
for each row
BEGIN
	delete from click where c_u_id = old.u_id;
	delete from limits where l_u_id = old.u_id;
END
 -- drop TRIGGER tri_del;
 
-- 触发器 更新用户时触发
create trigger tri_update
after update on users 
for each row
BEGIN
	update emigrated set e_user = new.u_name where e_user = old.u_name;
	update fight set f_user = new.u_name where f_user = old.u_name;
END
 -- drop TRIGGER tri_update;