MySQLdb如何按照列名访问结果

cursor.execute("select id, name from table")
rows = cursor.fetchall()
for row in rows:
print row.id, row.need_fetch

AttributeError: 'tuple' object has no attribute 'id'

求教V2EX高手，如何按照列名来访问不要row[0]这种方式

row

Rows

5 条回复 • 1970-01-01 08:00:00 +08:00

hahastudio

2013-08-20 18:18:33 +08:00

import MySQLdb
db = MySQLdb.connect( ... )
cur = db.cursor(MySQLdb.cursors.DictCursor)
cur.execute('select * from test;')

>>> cur.fetchone()
{'a': 1L, 'c': 3L, 'b': 2L}

kenneth

2013-08-20 18:28:46 +08:00

@hahastudio 可能你没理解我的问题

hahastudio

2013-08-20 19:23:51 +08:00

@kenneth
>>> rows = cursor.fetchall()
>>> for row in rows:
>>> for row in rows:
... print row['a'], row['c']
...
2 3
2 4
3 3
1 2

都字典了，该怎么按照 column name 访问不是很明确吗，一定要用namedtuple访问的话你构造一个呗= =
哦，顺带一提，我这列的名字就叫a, b, c= =

SErHo

2013-08-20 19:42:05 +08:00

Tornado 中有个这种方法：
https://github.com/facebook/tornado/blob/branch2.4/tornado/database.py#L121

lj0014

2013-08-21 10:13:52 +08:00

row = result.fetch_row(how=1)[0]
row['a']
row['b']
...