使用MySQLdb连接MySQL进行操作时的一个问题

CODE:

import MySQLdb

conn = MySQLdb.connect(host='192.168.4.59',
                       user='bibby',
                       passwd='bibby',
                       db='mysqldb')

cursor = conn.cursor()

cursor.execute('''show tables''')
tables = cursor.fetchmany()
print "Tables :",tables

cursor.close()
conn.close()

CODE:

print "Tables :",tables
print tables[0]
print tables[1]

CODE:

Tables : (('mysqldbtest',), ('mysqldbtest2',))
('mysqldbtest',)
('mysqldbtest2',)

CODE:

print "Tables :",tables
print tables[0][0]
print tables[1][0]

CODE:

Tables : (('mysqldbtest',), ('mysqldbtest2',))
mysqldbtest
mysqldbtest2

CODE:

tables = cursor.fetchall()
print "Tables :",tables

QUOTE:

原帖由 wolfg 于 2005-12-31 11:41 发表
还是没搞清楚fetchmany()为啥不行

http://www.devshed.com/index2.ph ... age=0&hide_js=1

CODE:

def fetchmany(self, size=None):
        """Fetch up to size rows from the cursor. Result set may be smaller
        than size. If size is not defined, cursor.arraysize is used."""
        self._check_executed()
        end = self.rownumber + (size or self.arraysize)
        result = self._rows[self.rownumber:end]
        self.rownumber = min(end, len(self._rows))
        return result