用IF/ELSE IF更新多条记录？

# 导入数据库操作库
import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', database='mydb')
cursor = conn.cursor()

# 查询需要更新的记录集合
query = "SELECT * FROM mytable WHERE condition = 'value'"
cursor.execute(query)
records = cursor.fetchall()

# 循环遍历记录集合并更新
for record in records:
    # 根据特定条件执行更新操作
    if record['field'] == 'value1':
        update_query = "UPDATE mytable SET field = 'new_value1' WHERE id = %s"
        cursor.execute(update_query, (record['id'],))
    elif record['field'] == 'value2':
        update_query = "UPDATE mytable SET field = 'new_value2' WHERE id = %s"
        cursor.execute(update_query, (record['id'],))
    else:
        # 其他条件的更新操作...

# 提交事务并关闭连接
conn.commit()
conn.close()