mysql触发过程

begin
declare sum int(0);
select count(*) into sum from bm51 where bzz='0';
if (sum<20) 
then    
UPDATE bm51 SET bzz='0';
end if;
end

 

posted @ 2021-11-02 16:50  myrj  阅读(48)  评论(0)    收藏  举报