MySQLdb如何按照列名访问结果

[kenneth]

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]这种方式

[hahastudio]

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]

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

[hahastudio]

@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]

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

[lj0014]

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