如何根据动态参数对基于动态参数的列进行条件排序？

import pymysql

def sort_data_by_dynamic_param(column, order):
    # 连接数据库
    conn = pymysql.connect(host='localhost', user='root', password='password', db='mydb')
    cursor = conn.cursor()

    # 构建排序条件
    if order == 'asc':
        order_by = 'ASC'
    else:
        order_by = 'DESC'
    sql = f"SELECT * FROM mytable ORDER BY {column} {order_by}"

    # 执行排序操作
    cursor.execute(sql)
    result = cursor.fetchall()

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

    return result

# 示例调用
column = 'age'  # 动态参数，需要根据实际情况传入
order = 'asc'   # 动态参数，需要根据实际情况传入
result = sort_data_by_dynamic_param(column, order)
print(result)