mysql拼接表名查询语句

import mysql.connector

def query_data(table_name, column_name, value):
    # 连接数据库
    db = mysql.connector.connect(
        host="localhost",
        user="yourusername",
        password="yourpassword",
        database="yourdatabase"
    )
    
    # 创建游标
    cursor = db.cursor()
    
    # 动态拼接SQL查询语句
    sql = f"SELECT * FROM {table_name} WHERE {column_name} = %s"
    
    # 执行查询
    cursor.execute(sql, (value,))
    
    # 获取结果
    results = cursor.fetchall()
    
    # 关闭连接
    cursor.close()
    db.close()
    
    return results

# 示例调用
results = query_data("users", "id", 1)
print(results)