Mysql中，选择多个行并以事务方式为每行分配不同的值

CREATE TEMPORARY TABLE temp_table
SELECT id FROM your_table WHERE condition;

START TRANSACTION;

DECLARE done INT DEFAULT FALSE;
DECLARE temp_id INT;
DECLARE cur CURSOR FOR SELECT id FROM temp_table;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

OPEN cur;

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

    -- 在这里为每行分配不同的值
    UPDATE your_table SET column_name = new_value WHERE id = temp_id;
END LOOP;

CLOSE cur;

COMMIT;