MYSQL添加外加一个in循环或for each

-- 创建一个存储过程
DELIMITER $$
CREATE PROCEDURE batch_update()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE id INT;
    DECLARE cur CURSOR FOR SELECT id FROM your_table;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
    
    OPEN cur;
    
    read_loop: LOOP
        FETCH cur INTO id;
        IF done THEN
            LEAVE read_loop;
        END IF;
        
        -- 执行相应的操作，例如更新数据
        UPDATE your_table SET column = 'value' WHERE id = id;
    END LOOP;
    
    CLOSE cur;
END$$
DELIMITER ;

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