本文共 673 字，大约阅读时间需要 2 分钟。

 

 

delimiter $$

drop function if exists checkPayoffStatus$$ create function checkPayoffStatus( mergeId INT(11),payoffType smallint(1) ) returns int

begin declare count int;       IF payoffType = 1 THEN       set count =  ( SELECT COUNT(payoff_status) count   FROM bu_payoff WHERE id IN (    SELECT payoff_id FROM bu_payoff_merge_sub WHERE merge_id = mergeId AND payoff_type = 1) AND payoff_status NOT IN (6,8)  );     ELSE       set count =  ( SELECT COUNT(payoff_status) count   FROM bu_payoff_one WHERE id IN (    SELECT payoff_id FROM bu_payoff_merge_sub WHERE merge_id = mergeId AND payoff_type = 2) AND payoff_status NOT IN (6,8)  );    END IF;    return count; end $$

delimiter ;

 

SELECT checkPayoffStatus(134,2);

转载地址：https://blog.csdn.net/liuming690452074/article/details/102659909 如侵犯您的版权，请留言回复原文章的地址，我们会给您删除此文章，给您带来不便请您谅解！