我无法在Python中更新SQL数据库，但可以添加新行

import pymysql

# 建立与数据库的连接
conn = pymysql.connect(host='localhost', port=3306, user='root', password='password', db='mydatabase')

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

# 执行更新操作的SQL语句
sql = "UPDATE mytable SET column1 = 'new value' WHERE id = 1"

try:
    # 执行SQL语句
    cursor.execute(sql)
    
    # 提交事务
    conn.commit()
    
    print("数据库更新成功！")
except Exception as e:
    # 发生错误时回滚事务
    conn.rollback()
    print("数据库更新失败：", str(e))

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

import pymysql

# 建立与数据库的连接
conn = pymysql.connect(host='localhost', port=3306, user='root', password='password', db='mydatabase')

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

# 执行插入操作的SQL语句
sql = "INSERT INTO mytable (column1, column2) VALUES ('value1', 'value2')"

try:
    # 执行SQL语句
    cursor.execute(sql)
    
    # 提交事务
    conn.commit()
    
    print("新行添加成功！")
except Exception as e:
    # 发生错误时回滚事务
    conn.rollback()
    print("新行添加失败：", str(e))

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