mysql 连接更新数据库

import mysql.connector

# 建立数据库连接
mydb = mysql.connector.connect(
  host="localhost",
  user="yourusername",
  password="yourpassword",
  database="yourdatabase"
)

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

# 更新单条记录
sql = "UPDATE customers SET address = 'Canyon 123' WHERE address = 'Valley 345'"
mycursor.execute(sql)
mydb.commit()

# 批量更新多条记录
sql = "UPDATE customers SET address = 'Canyon 123' WHERE address = 'Valley 345' OR address = 'Hill 678'"
mycursor.execute(sql)
mydb.commit()

# 条件更新
sql = "UPDATE customers SET address = 'Canyon 123' WHERE city = 'New York'"
mycursor.execute(sql)
mydb.commit()

# 事务更新
try:
    mydb.start_transaction()
    sql1 = "UPDATE customers SET address = 'Canyon 123' WHERE customer_id = 1"
    sql2 = "UPDATE orders SET order_status = 'Shipped' WHERE customer_id = 1"
    mycursor.execute(sql1)
    mycursor.execute(sql2)
    mydb.commit()
except mysql.connector.Error as err:
    print("Transaction failed: {}".format(err))
    mydb.rollback()
finally:
    mycursor.close()
    mydb.close()