mysql for遍历数组

DELIMITER //

CREATE PROCEDURE BatchUpdate(IN ids VARCHAR(255))
BEGIN
    DECLARE i INT DEFAULT 1;
    DECLARE id INT;
    DECLARE done INT DEFAULT FALSE;

    -- 将逗号分隔的ID字符串转换为临时表
    CREATE TEMPORARY TABLE temp_ids (id INT);
    SET @sql = CONCAT('INSERT INTO temp_ids VALUES (', REPLACE(ids, ',', '),('), ')');
    PREPARE stmt FROM @sql;
    EXECUTE stmt;
    DEALLOCATE PREPARE stmt;

    -- 获取临时表中的记录数
    SET @count = (SELECT COUNT(*) FROM temp_ids);

    -- 遍历临时表并更新数据
    my_loop: LOOP
        FETCH temp_ids INTO id;
        IF done THEN
            LEAVE my_loop;
        END IF;

        UPDATE your_table SET status = 'updated' WHERE id = id;
        SET i = i + 1;
    END LOOP;

    -- 删除临时表
    DROP TEMPORARY TABLE temp_ids;
END //

DELIMITER ;