mysql 存储过程

最新推荐文章于 2025-06-25 22:43:14 发布

taking_wang

最新推荐文章于 2025-06-25 22:43:14 发布

阅读量402

点赞数

CC 4.0 BY-SA版权

分类专栏： db_mysql

本文链接：https://blog.youkuaiyun.com/taking_wang/article/details/41978211

db_mysql 专栏收录该内容

10 篇文章

订阅专栏

本文介绍了一个用于更新交易绩效数据存储过程的实现，包括声明变量、游标操作、循环处理以及数据库更新等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

CREATE PROCEDURE updateTradePerformanceData()
BEGIN
       declare stopFlag int;
       declare parentOrgId varchar(100);
       declare orgaid varchar(100);
       DECLARE dataid varchar(100);
       declare hasCount int;
        -- 申明游标
       declare tradePerformanceCuror cursor for
               select
                   fid,fkorgaid
               from t_trade_performance;

-- 申明跳出循环

   DECLARE CONTINUE HANDLER FOR NOT FOUND set stopFlag=1;
   OPEN tradePerformanceCuror;
           REPEAT
           FETCH tradePerformanceCuror INTO dataid,orgaid;
           BEGIN
       select count(1) into hasCount from t_bd_org o where o.fid = orgaid;
         if (orgaid is not null and hasCount > 0) then
            select o.fkparentid into parentOrgId from t_bd_org o where o.fid = orgaid;
            update t_trade_performance set fkorgbid = parentOrgId where fid = dataid;
                -- 处理逻辑
       end if;
       commit;
       END;
           UNTIL stopFlag = 1
               END REPEAT;
               CLOSE tradePerformanceCuror;
END;