更新用户正在查看的表的方法？

import mysql.connector

# 连接到MySQL数据库
cnx = mysql.connector.connect(user='username', password='password',
                              host='localhost', database='database_name')

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

# 查询表中的数据
query = "SELECT * FROM table_name WHERE condition"
cursor.execute(query)
result = cursor.fetchall()
print("Before update:")
for row in result:
    print(row)

# 更新表中的数据
update_query = "UPDATE table_name SET column1 = new_value WHERE condition"
cursor.execute(update_query)
cnx.commit()
print("Update successful!")

# 再次查询表中的数据
cursor.execute(query)
result = cursor.fetchall()
print("After update:")
for row in result:
    print(row)

# 关闭游标和数据库连接
cursor.close()
cnx.close()