为Table1的每一列在Table2中插入新行

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='your_database')

# 创建游标对象
cursor = cnx.cursor()

# 查询Table1的列名
query = "SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Table1';"
cursor.execute(query)
columns = cursor.fetchall()

# 遍历每一列
for column in columns:
    column_name = column[0]
    
    # 查询Table1中的该列的所有值
    query = "SELECT {} FROM Table1;".format(column_name)
    cursor.execute(query)
    values = cursor.fetchall()
    
    # 遍历每个值，插入Table2
    for value in values:
        new_row = {
            column_name: value[0],
            # 添加其他列对应的属性值
        }
        
        # 插入新行到Table2
        query = "INSERT INTO Table2 ({}) VALUES ({})".format(
            ', '.join(new_row.keys()),
            ', '.join(['%s'] * len(new_row))
        )
        cursor.execute(query, tuple(new_row.values()))
        cnx.commit()

# 关闭游标和数据库连接
cursor.close()
cnx.close()