Mysql数据库存储过程中PREPARE批处理的使用例子

DECLARE temp varchar(20);
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_departments = 1;
    DECLARE cur_users CURSOR FOR SELECT LoginID FROM t_userinfos WHERE UcNumber IN (SELECT uc_number FROM t_reg_numbers WHERE reg_state=4);
    SET no_more_departments=0;
    
    OPEN cur_users;
    REPEAT
    FETCH cur_users INTO tempTable;
        SET @vSQL = concat('UPDATE ',tempTable,' SET PushStatus = 0 WHERE PushStatus=-1 limit 10');
        SET @vSQLS = concat(@vSQLS,'SELECT  SmsID,SendNumber,RecvNumber,SmsContent,ID FROM ',tempTable,' WHERE PushStatus=1 ');
        PREPARE stmt FROM @vSQL;
        EXECUTE stmt;
    UNTIL no_more_departments
    DEALLOCATE PREPARE stmt;
    END REPEAT;
    CLOSE cur_users;