使用动态生成的字段创建Sqlite表

import sqlite3

def create_table(table_name, fields):
    conn = sqlite3.connect('database.db')
    cursor = conn.cursor()

    # 构建CREATE TABLE语句
    sql = f"CREATE TABLE {table_name} (id INTEGER PRIMARY KEY AUTOINCREMENT, "
    for field in fields:
        sql += f"{field} TEXT, "
    sql = sql.rstrip(", ") + ")"

    # 执行SQL语句
    cursor.execute(sql)
    conn.commit()

    conn.close()

# 示例调用
fields = ['name', 'age', 'email']
create_table('my_table', fields)

import sqlite3

def create_table(table_name, fields):
    conn = sqlite3.connect('database.db')
    cursor = conn.cursor()

    # 创建虚拟表
    sql = f"CREATE VIRTUAL TABLE {table_name} USING fts4("
    for field in fields:
        sql += f"{field} TEXT, "
    sql = sql.rstrip(", ") + ")"

    # 执行SQL语句
    cursor.execute(sql)
    conn.commit()

    conn.close()

# 示例调用
fields = ['name', 'age', 'email']
create_table('my_table', fields)