在不知道表的列的情况下向动态mysql表插入值

import mysql.connector

def insert_dynamic_values(table_name, values):
    # 连接MySQL数据库
    cnx = mysql.connector.connect(user='username', password='password', host='localhost', database='database_name')
    cursor = cnx.cursor()

    # 获取表的列信息
    cursor.execute("DESCRIBE " + table_name)
    columns = [column[0] for column in cursor.fetchall()]

    # 构建动态插入语句
    insert_statement = "INSERT INTO " + table_name + " (" + ", ".join(columns) + ") VALUES ("
    for value in values:
        insert_statement += "'" + value + "', "
    insert_statement = insert_statement.rstrip(", ") + ")"

    # 执行插入操作
    cursor.execute(insert_statement)
    cnx.commit()

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

# 示例调用
table_name = "dynamic_table"
values = ["value1", "value2", "value3"]
insert_dynamic_values(table_name, values)