mysql遍历数据库并修改记录

import mysql.connector

# 连接数据库
conn = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

# 创建游标对象
cursor = conn.cursor()

# 查询需要修改的记录
query = "SELECT * FROM yourtable WHERE condition = 'yourcondition'"
cursor.execute(query)

# 遍历结果集
for row in cursor.fetchall():
    # 获取需要修改的字段的值
    value = row[0]  # 假设需要修改的字段是第一个字段

    # 修改记录
    update_query = "UPDATE yourtable SET column = 'newvalue' WHERE condition = 'yourcondition'"
    cursor.execute(update_query)

# 提交更改
conn.commit()

# 关闭连接
cursor.close()
conn.close()