如何使用列表元素更新数据库？

import mysql.connector

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

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

# 查询数据库获取要更新的数据
query = "SELECT id, name FROM table_name WHERE condition = 'value'"
cursor.execute(query)

# 获取查询结果
results = cursor.fetchall()

# 更新数据
for row in results:
    id = row[0]
    name = row[1]
    new_name = name + " updated"

    # 更新数据库中的记录
    update_query = "UPDATE table_name SET name = %s WHERE id = %s"
    cursor.execute(update_query, (new_name, id))

# 提交更改
cnx.commit()

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