Python 中的資料庫 DELETE 操作

當你要從資料庫中刪除一些記錄時，需要 DELETE 操作。以下是在 EMPLOYEE 中刪除 AGE 大於 20 的所有記錄的過程 −

示例

#!/usr/bin/python
import MySQLdb
# Open database connection
db = MySQLdb.connect("localhost","testuser","test123","TESTDB" )
# prepare a cursor object using cursor() method
cursor = db.cursor()
# Prepare SQL query to DELETE required records
sql = "DELETE FROM EMPLOYEE WHERE AGE > '%d'" % (20)
try:
   # Execute the SQL command
   cursor.execute(sql)
   # Commit your changes in the database
   db.commit()
except:
   # Rollback in case there is any error
   db.rollback()
# disconnect from server
db.close()

Mohd Mohtashim

更新於： 31-Jan-2020

228 次瀏覽

開啟 職業生涯

透過完成課程獲得認證

開始