Python中的数据库删除操作
要从数据库中删除某些记录时，需要执行DELETE操作。以下是从AGE大于20的EMPLOYEE删除所有记录的过程-
示例
#!/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()热门推荐
10 18岁的祝福语简短
11 新年祝福语简短句子
12 五二零朋友祝福语大全简短
13 六一加端午祝福语简短
14 對好友毕业祝福语简短
15 七一祝福语明信片文案简短
16 简短中秋祝福语朋友结婚
17 关于扬州的祝福语简短
18 韩语贺卡祝福语简短版