Python -如何根据DF和其中的数据制作SQL "Create Table“语句？

import pandas as pd

# 创建一个示例DataFrame
data = {'Name': ['John', 'Emma', 'Mike'],
        'Age': [25, 28, 30],
        'City': ['New York', 'London', 'Paris']}
df = pd.DataFrame(data)

# 生成SQL "Create Table"语句
table_name = 'my_table'
create_table_sql = f"CREATE TABLE {table_name} ("
for column in df.columns:
    column_name = column
    column_type = df[column].dtype
    if column_type == 'object':
        column_type = 'VARCHAR(255)'
    elif column_type == 'int64':
        column_type = 'INT'
    elif column_type == 'float64':
        column_type = 'FLOAT'
    create_table_sql += f"{column_name} {column_type}, "
create_table_sql = create_table_sql.rstrip(', ') + ");"

print(create_table_sql)

CREATE TABLE my_table (Name VARCHAR(255), Age INT, City VARCHAR(255));