数据库操作（Python如何更新MySQL（）） _Python最新开发教程

UPDATE-SET语句用于更新表中的任何列。以下SQL查询用于更新列。

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

考虑以下示例。
例子

import mysql.connector#Create the connection object myconn = mysql.connector.connect(host = "localhost", user = "root", passwd = "google", database = "PythonDB")#creating the cursor objectcur = myconn.cursor()try:#updating the name of the employee whose id is 110cur.execute("update Employee set name = 'alex' where id = 110")myconn.commit()except:myconn.rollback()myconn.close()

文章图片
删除操作 DELETE FROM语句用于从表中删除特定记录。在这里, 我们必须使用WHERE子句强加条件, 否则将从表中删除所有记录。
以下SQL查询用于从表中删除ID为110的员工明细。

> delete from Employee where id = 110

【数据库操作（Python如何更新MySQL（））】考虑以下示例。
例子

import mysql.connector#Create the connection object myconn = mysql.connector.connect(host = "localhost", user = "root", passwd = "google", database = "PythonDB")#creating the cursor objectcur = myconn.cursor()try:#Deleting the employee details whose id is 110cur.execute("delete from Employee where id = 110")myconn.commit()except:myconn.rollback()myconn.close()