存储过程中使用多游标实例 mysql

最新推荐文章于 2024-07-03 03:40:17 发布

原创

最新推荐文章于 2024-07-03 03:40:17 发布 · 323 阅读

1 ·

CC 4.0 BY-SA版权

本文详细探讨了如何在MySQL存储过程中使用多个游标，通过实例讲解了游标的创建、打开、关闭及遍历操作，展示了如何在存储过程中进行复杂的数据处理和流程控制。内容包括游标的基本概念、语法以及在实际问题解决中的应用。

drop procedure if exists get_qrcode_daily_statistic;
delimiter ;;
create procedure get_qrcode_daily_statistic()
begin
    #声明下面要用到的变量
    declare allet_union_out int;
    declare ribbon_union_out int;
    declare union_out_amount decimal;
    declare allet_union_stay int;
    declare ribbon_union_stay int;
    declare union_stay_amount decimal;
    declare allet_company_out int;
    declare ribbon_company_out int;
    declare company_out_amount decimal;
    
    #创建多个游标
    declare unionOut cursor for select sum(allet_card) as allet_union_out,sum(ribbon_card) as ribbon_union_out,sum(allet_card_amount) + sum(ribbon_card_amount) as union_out_amount from lh_bill_info where state = 2 and hand_out = 1 and `status` = 1;
    declare unionStay cursor for select sum(allet_card) as allet_union_stay,sum(ribbon_card) as ribbon_union_stay,sum(allet_card_amount) + sum(ribbon_card_amount) as union_stay_amount from lh_bill_info where state = 2 and hand_out =