mysql while循环查询

DELIMITER //

CREATE PROCEDURE BatchUpdate()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE v_id INT;
    DECLARE v_value INT;

    -- 假设有一个名为 `my_table` 的表，包含 `id` 和 `value` 两个字段
    DECLARE cur CURSOR FOR SELECT id, value FROM my_table WHERE value < 50;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO v_id, v_value;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 更新逻辑：将 value 值增加 10
        UPDATE my_table SET value = value + 10 WHERE id = v_id;
    END LOOP;

    CLOSE cur;
END //

DELIMITER ;