与使用psycopg2的PostgreSQL中的更新表的比较不起作用

UPDATE table_name SET column1 = value1 WHERE condition;

conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpass", host="yourhost", port="yourport")
cur = conn.cursor()
try:
    cur.execute("UPDATE table_name SET column1 = value1 WHERE condition;")
    conn.commit()
except psycopg2.Error as e:
    print(f"Error: {e}")
    conn.rollback()
finally:
    cur.close()
    conn.close()

import psycopg2

# 连接到数据库
conn = psycopg2.connect(database="yourdb", user="youruser", password="yourpass", host="yourhost", port="yourport")
cur = conn.cursor()

# 更新语句
update_query = """
UPDATE table_name
SET column1 = 'new_value'
WHERE column2 = 'some_value';
"""

try:
    # 执行更新
    cur.execute(update_query)
    # 提交事务
    conn.commit()
    print("Update successful")
except psycopg2.Error as e:
    # 发生错误时回滚
    print(f"Error updating record: {e}")
    conn.rollback()
finally:
    # 关闭连接
    cur.close()
    conn.close()