#!/usr/bin/python# 
-*- coding: UTF-8 -*-
import MySQLdb

# 打開數(shù)據(jù)庫連接
db = MySQLdb.connect("localhost", "testuser", "test123", "TESTDB", charset='utf8' )

# 使用cursor()方法獲取操作游標(biāo)
 cursor = db.cursor()
 
# SQL 更新語句
sql = "UPDATE EMPLOYEE SET AGE = AGE + 1 WHERE SEX = '%c'" % ('M')
try:
 # 執(zhí)行SQL語句
 cursor.execute(sql)
 # 提交到數(shù)據(jù)庫執(zhí)行
 db.commit()
except:
 # 發(fā)生錯(cuò)誤時(shí)回滾
 db.rollback()
 
# 關(guān)閉數(shù)據(jù)庫連接
db.close()

#!/usr/bin/python
# -*- coding: UTF-8 -*-

import MySQLdb

# 打開數(shù)據(jù)庫連接
db = MySQLdb.connect("localhost", "testuser", "test123", "TESTDB", charset='utf8' )

# 使用cursor()方法獲取操作游標(biāo) 
cursor = db.cursor()

# SQL 刪除語句
sql = "DELETE FROM EMPLOYEE WHERE AGE > '%d'" % (20)
try:
 # 執(zhí)行SQL語句
 cursor.execute(sql)
 # 提交修改
 db.commit()
except:
 # 發(fā)生錯(cuò)誤時(shí)回滾
 db.rollback()
 
# 關(guān)閉連接
db.close(