检查SQL中是否已更新行的最佳方法

SELECT * FROM your_table WHERE your_condition;

SELECT * FROM users WHERE name='John' AND age=18;

import pymysql

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

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

# 执行查询
cursor.execute('SELECT * FROM users WHERE name=%s AND age=%s', ('John', 18))

# 检查是否有结果
if cursor.fetchone() is None:
    print('行尚未更新')
else:
    print('行已更新')

# 关闭游标和连接
cursor.close()
conn.close()