实例：
查询EMPLOYEE表中salary（工资）字段大于1000的所有数据：
#!/usr/bin/python
# -*- coding: UTF-8 -*-
importMySQLdb
# 打开数据库连接
db =MySQLdb.connect("localhost","testuser","test123","TESTDB", charset='utf8')
# 使用cursor()方法获取操作游标
cursor = db.cursor()
# SQL 查询语句
sql ="SELECT * FROM EMPLOYEE \
WHERE INCOME > %s"%(1000)
try:
# 执行SQL语句
cursor.execute(sql)
# 获取所有记录列表
results = cursor.fetchall()
for row in results:
fname = row[0]
lname = row[1]
age = row[2]
sex = row[3]
income = row[4]
# 打印结果
print"fname=%s,lname=%s,age=%s,sex=%s,income=%s"% \
(fname, lname, age, sex, income )
except:
print"Error: unable to fetch data"
# 关闭数据库连接
db.close()
以上脚本执行结果如下：
fname=Mac, lname=Mohan, age=20, sex=M, income=2000
