#!/usr/bin/python

# -*- coding: UTF-8 -*-

import MySQLdb

db = MySQLdb.connect("192.168.1.1", "root", "111111", "test" )

cursor = db.cursor()

cursor.execute("SELECT * FROM booksales")

results = cursor.fetchall()

for row in results:

    fname = row[0]

    lname = row[1]

    # 打印结果

    print "fname=%s,lname=%s" % \

          (fname , lname)

db.close()

fname=Java Web,lname=51200

fname=Java??,lname=63000

fname=Linux??,lname=38500

fname=TCP/IP??,lname=59000

fname=UNIX??,lname=53000

fname=????,lname=78900

db = MySQLdb.connect("192.168.1.1", "root", "111111", "test",charset="utf8")

问题得到解决。