这段代码通过MySQLdb模块连接mysql数据库，然后查询employee表中income字段大于1000的数据输出

#!/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.  sql = "SELECT * FROM EMPLOYEE \         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()