mysql 动态sql传参数

import mysql.connector

def dynamic_query(table_name, column_name, value):
    # 连接数据库
    conn = mysql.connector.connect(
        host="localhost",
        user="your_username",
        password="your_password",
        database="your_database"
    )
    cursor = conn.cursor()

    # 构建动态SQL语句
    sql = f"SELECT * FROM {table_name} WHERE {column_name} = %s"
    params = (value,)

    # 执行SQL语句
    cursor.execute(sql, params)
    result = cursor.fetchall()

    # 关闭连接
    cursor.close()
    conn.close()

    return result

# 示例调用
table_name = "users"
column_name = "age"
value = 25
result = dynamic_query(table_name, column_name, value)
print(result)