我是否可以将动态值传递给我的选择查询字段

import mysql.connector

def dynamic_field_query(field):
    cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
    cursor = cnx.cursor()

    query = "SELECT {} FROM users".format(field)
    cursor.execute(query)

    result = cursor.fetchall()

    cursor.close()
    cnx.close()

    return result

import mysql.connector

def parameterized_field_query(field):
    cnx = mysql.connector.connect(user='your_username', password='your_password',
                              host='your_host', database='your_database')
    cursor = cnx.cursor()

    query = "SELECT %s FROM users"
    cursor.execute(query, (field,))

    result = cursor.fetchall()

    cursor.close()
    cnx.close()

    return result