插入来自未知列数和列名的临时表(来自动态透视查询)

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database')
cursor = conn.cursor()

# 创建临时表
create_table_query = "CREATE TABLE temp_table (Column1 VARCHAR(255), Column2 VARCHAR(255), ...)"
cursor.execute(create_table_query)

# 执行动态透视查询
dynamic_pivot_query = "SELECT * FROM dynamic_pivot_query"
cursor.execute(dynamic_pivot_query)
result = cursor.fetchall()

# 动态生成插入语句
insert_query = "INSERT INTO temp_table VALUES ("
for row in result:
    values = []
    for value in row:
        values.append("'" + str(value) + "'")
    insert_query += ", ".join(values) + "), ("
insert_query = insert_query[:-3]  # 去除最后一个多余的逗号和括号

# 执行插入语句
cursor.execute(insert_query)

# 提交事务并关闭连接
conn.commit()
cursor.close()
conn.close()