Mysql触发器

最新推荐文章于 2025-05-12 13:59:36 发布

aichun8580

最新推荐文章于 2025-05-12 13:59:36 发布

阅读量66

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/licunzhi/p/9121200.html

版权

create trigger tapp_trigger after update
on business FOR EACH ROW
begin  
set @count = (select count(*) from temp where business_id = old.id);
set @Differ = (SELECT sum(TIMESTAMPDIFF(minute , create_time, modify_time)) from business where id = old.id );
if @count = 0 then  
	insert into temp(business_id, start_time, differ) values(old.id, old.create_time, @Differ);
elseif @count > 0 THEN
	update temp set differ=@Differ where business_id = old.id;
end if;  
end;

转载于:https://www.cnblogs.com/licunzhi/p/9121200.html