mysql循环判断相等

DELIMITER //

CREATE PROCEDURE UpdateColumnUntilEqual()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE counter INT DEFAULT 0;
    DECLARE currentValue INT;

    -- 假设我们有一个表名为 `my_table`，其中有一列名为 `value`
    DECLARE cur CURSOR FOR SELECT value FROM my_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO currentValue;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 假设我们要将 `value` 列的值更新为 10，直到所有值都等于 10
        IF currentValue < 10 THEN
            UPDATE my_table SET value = value + 1 WHERE CURRENT OF cur;
        END IF;

        SET counter = counter + 1;
    END LOOP;

    CLOSE cur;

    SELECT counter AS 'Updated Rows';
END //

DELIMITER ;

CALL UpdateColumnUntilEqual();