查找最低值和输出用户名

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='database_name')

# 创建游标
cursor = cnx.cursor()

# 查询最低值
query = "SELECT MIN(value) FROM user_table"
cursor.execute(query)
min_value = cursor.fetchone()[0]

# 查询对应的用户名
query = "SELECT username FROM user_table WHERE value = %s"
cursor.execute(query, (min_value,))
usernames = cursor.fetchall()

# 输出结果
print("最低值：", min_value)
print("对应的用户名：")
for username in usernames:
    print(username[0])

# 关闭游标和数据库连接
cursor.close()
cnx.close()