mysql函数表循环

DELIMITER //

CREATE PROCEDURE UpdateStatus()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE v_id INT;
    DECLARE v_status VARCHAR(20);
    
    -- 定义游标
    DECLARE cur CURSOR FOR SELECT id, status FROM your_table WHERE status = '待审核';
    
    -- 定义结束标志
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    
    OPEN cur;
    
    read_loop: LOOP
        FETCH cur INTO v_id, v_status;
        
        IF done THEN
            LEAVE read_loop;
        END IF;
        
        -- 更新状态
        UPDATE your_table SET status = '已审核' WHERE id = v_id;
    END LOOP;
    
    CLOSE cur;
END //

DELIMITER ;

-- 调用存储过程
CALL UpdateStatus();