更新表中的已有记录
更新表中的已有记录详细操作教程
以下实例为学习更新表中的已有记录,具体代码如下:
# Filename : example.py
# Author by : www.lidihuo.com
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="myusername",
passwd="mypassword",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "UPDATE customers SET address = 'Canyon 123' WHERE address = 'Valley 345'"
mycursor.execute(sql)
mydb.commit()
print(mycursor.rowcount, "record(s) affected")
执行以上代码输出结果为:
# Filename : example.py
# Author by : www.lidihuo.com
1 record(s) affected