如何在不逐行运行每组条件的每个update语句的情况下批量更新

import pymysql

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

# 开启事务
conn.begin()

try:
    # 构建更新语句
    update_sql = "UPDATE table_name SET column1 = value1, column2 = value2 WHERE condition"

    # 执行更新操作
    cursor.execute(update_sql)

    # 提交事务
    conn.commit()
    print("批量更新成功！")
except Exception as e:
    # 回滚事务
    conn.rollback()
    print("批量更新失败：", str(e))

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