纯 MySQL 循环更新多行

SET @i = 0;
UPDATE your_table
SET your_column = CASE
    WHEN @i = 0 THEN 'value1'
    WHEN @i = 1 THEN 'value2'
    WHEN @i = 2 THEN 'value3'
    ELSE 'default_value'
END,
@i = @i + 1
WHERE id BETWEEN 1 AND 3;

DECLARE @i INT DEFAULT 0;
DECLARE @max_id INT;
SELECT @max_id = MAX(id) FROM your_table;
WHILE @i <= @max_id DO
    UPDATE your_table
    SET your_column = 'value'
    WHERE id = @i;
    SET @i = @i + 1;
END WHILE;