如何在mysql中将静态数据透视表转换为动态数据透视表？

DELIMITER //

CREATE PROCEDURE convert_pivot_table()
BEGIN
    -- 创建新表
    CREATE TABLE dynamic_pivot_table (
        -- 添加动态列
        id INT
    );

    -- 插入静态数据透视表的数据
    INSERT INTO dynamic_pivot_table (id)
    SELECT id
    FROM static_pivot_table;

    -- 动态添加列
    DECLARE done INT DEFAULT FALSE;
    DECLARE column_name VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT column_name FROM information_schema.columns WHERE table_name = 'static_pivot_table' AND column_name != 'id';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

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

        SET @sql = CONCAT('ALTER TABLE dynamic_pivot_table ADD COLUMN ', column_name, ' INT');
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;

    CLOSE cur;

    -- 更新动态数据透视表的数据
    DECLARE done2 INT DEFAULT FALSE;
    DECLARE column_name2 VARCHAR(255);
    DECLARE cur2 CURSOR FOR SELECT column_name FROM information_schema.columns WHERE table_name = 'static_pivot_table' AND column_name != 'id';
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done2 = TRUE;

    OPEN cur2;

    read_loop2: LOOP
        FETCH cur2 INTO column_name2;
        IF done2 THEN
            LEAVE read_loop2;
        END IF;

        SET @sql2 = CONCAT('UPDATE dynamic_pivot_table SET ', column_name2, ' = (SELECT ', column_name2, ' FROM static_pivot_table WHERE static_pivot_table.id = dynamic_pivot_table.id)');
        PREPARE stmt2 FROM @sql2;
        EXECUTE stmt2;
        DEALLOCATE PREPARE stmt2;
    END LOOP;

    CLOSE cur2;

    -- 查询动态数据透视表的结果
    SELECT * FROM dynamic_pivot_table;

END //

DELIMITER ;