python通过MySQLdb模块连接查询mysql数据的代码

将写内容过程中比较重要的一些内容片段做个备份，下边内容是关于python通过MySQLdb模块连接查询mysql数据的内容，应该对码农有帮助。

#!/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 INSERT a record into the database.
       WHERE INCOME > '%d'" % (1000)
try:
   # Execute the SQL command
   cursor.execute(sql)
   # Fetch all the rows in a list of lists.
   results = cursor.fetchall()
   for row in results:
      fname = row[0]
      lname = row[1]
      age = row[2]
      sex = row[3]
      income = row[4]
      # Now print fetched result
      print "fname=%s,lname=%s,age=%d,sex=%s,income=%d" % 
             (fname, lname, age, sex, income )
except:
   print "Error: unable to fecth data"

# disconnect from server
db.close()



                                
                        
                                
输出结果
                                
                        
                                

fname=Mac, lname=Mohan, age=20, sex=M, income=2000