Python - 更新操作

>  update Employee set name = 'alex' where id = 110

import mysql.connector

#创建连接对象 
myconn = mysql.connector.connect(host = "localhost", user = "root",passwd = "Learnfk",database = "PythonDB")

#创建光标对象
cur = myconn.cursor()

try:
    #更新 id 为 110 的员工姓名
    cur.execute("update Employee set name = 'alex' where id = 110")
    myconn.commit()
except:
    
    myconn.rollback()

myconn.close()

>  delete from Employee where id = 110

import mysql.connector

#创建连接对象 
myconn = mysql.connector.connect(host = "localhost", user = "root",passwd = "Learnfk",database = "PythonDB")

#创建光标对象
cur = myconn.cursor()

try:
    #删除id为110的员工信息
    cur.execute("delete from Employee where id = 110")
    myconn.commit()
except:
    
    myconn.rollback()

myconn.close()