mysql 查询动态sql语句

import mysql.connector

def dynamic_query(table_name, column_name, value):
    try:
        # 连接数据库
        conn = mysql.connector.connect(user='user', password='password', host='host', database='database')
        cursor = conn.cursor()
        
        # 动态生成SQL语句
        sql = f"SELECT * FROM {table_name} WHERE {column_name} = %s"
        
        # 执行查询
        cursor.execute(sql, (value,))
        result = cursor.fetchall()
        
        # 输出结果
        for row in result:
            print(row)
    except mysql.connector.Error as err:
        print(f"Error: {err}")
    finally:
        # 关闭连接
        if conn.is_connected():
            cursor.close()
            conn.close()

# 调用函数
dynamic_query('users', 'username', 'admin')