如何检查行是否已更新？

SELECT COUNT(*) FROM table_name WHERE condition;

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='database_name', charset='utf8mb4')
cursor = conn.cursor()

# 执行查询操作
sql = "SELECT COUNT(*) FROM table_name WHERE condition;"
cursor.execute(sql)
result = cursor.fetchone()

# 判断查询结果
if result[0] > 0:
    print("行已存在")
else:
    print("行不存在")

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

START TRANSACTION;
SELECT COUNT(*) FROM table_name WHERE condition FOR UPDATE;
-- 在此处执行更新操作
COMMIT;