正在尝试将pandas数据帧插入到临时表

import pandas as pd
import pymysql

# 创建pandas数据帧
data = {'Name': ['John', 'Emma', 'Mike'],
        'Age': [25, 28, 30],
        'City': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

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

# 创建临时表
create_table_query = "CREATE TEMPORARY TABLE temp_table (Name VARCHAR(255), Age INT, City VARCHAR(255))"
cursor = conn.cursor()
cursor.execute(create_table_query)

# 将数据帧转换为SQL插入语句
insert_query = "INSERT INTO temp_table (Name, Age, City) VALUES (%s, %s, %s)"
values = [tuple(row) for row in df.values]

# 执行SQL插入语句
cursor.executemany(insert_query, values)
conn.commit()

# 关闭数据库连接
cursor.close()
conn.close()