使用python从一个数据库中的另一个数据库创建一个类似的表

import pymysql

# 连接到源数据库
source_conn = pymysql.connect(host='source_host', port=3306, user='source_user', password='source_password', database='source_database')
source_cursor = source_conn.cursor()

# 查询源数据库表结构
source_cursor.execute("SELECT table_name, column_name, data_type FROM information_schema.columns WHERE table_schema = 'source_database'")
table_structure = source_cursor.fetchall()

# 连接到目标数据库
target_conn = pymysql.connect(host='target_host', port=3306, user='target_user', password='target_password', database='target_database')
target_cursor = target_conn.cursor()

# 创建目标数据库表
for table_name, column_name, data_type in table_structure:
    create_table_query = f"CREATE TABLE {table_name} ({column_name} {data_type})"
    target_cursor.execute(create_table_query)

# 复制数据
for table_name, _, _ in table_structure:
    select_data_query = f"SELECT * FROM {table_name}"
    source_cursor.execute(select_data_query)
    data = source_cursor.fetchall()

    insert_data_query = f"INSERT INTO {table_name} VALUES ({','.join(['%s'] * len(data[0]))})"
    target_cursor.executemany(insert_data_query, data)

# 提交事务并关闭连接
target_conn.commit()
target_cursor.close()
target_conn.close()
source_cursor.close()
source_conn.close()