mysql合并多个表

import pyodbc

# 连接到 SQL Server 数据库
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=your_server;DATABASE=your_database;UID=your_username;PWD=your_password')
cursor = conn.cursor()

# 创建一个临时表
cursor.execute("SELECT * INTO temp_table FROM first_table")
conn.commit()

# 查找要合并的表名
table_names = ['second_table', 'third_table', 'fourth_table']

# 合并其他表到临时表
for table_name in table_names:
    cursor.execute(f"INSERT INTO temp_table SELECT * FROM {table_name}")
    conn.commit()

# 关闭连接
cursor.close()
conn.close()