存储过程中使用多游标实例 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 wh