Python MySQLdb模块问题多表连接key查询，pythonmysqldb,表结构:post:+--

Python MySQLdb模块问题多表连接key查询，pythonmysqldb,表结构:post:+--

表结构:
post:

+---------+----------+------+-----+---------+----------------+| Field   | Type     | Null | Key | Default | Extra          |+---------+----------+------+-----+---------+----------------+| id      | int(11)  | NO   | PRI | NULL    | auto_increment || name    | char(30) | YES  |     | NULL    |                || user_id | int(11)  | YES  |     | NULL    |                |+---------+----------+------+-----+---------+----------------+

user:

+---------+----------+------+-----+---------+----------------+| Field   | Type     | Null | Key | Default | Extra          |+---------+----------+------+-----+---------+----------------+| user_id | int(11)  | NO   | PRI | NULL    | auto_increment || name    | char(30) | YES  |     | NULL    |                || email   | char(30) | YES  |     | NULL    |                |+---------+----------+------+-----+---------+----------------+

查询结果是数据dict的元组。

但是我觉得这个数据dict的keys很难以琢磨:

['post.user_id', 'user_id', 'name', 'email', 'post.name', 'id']

问题就是:我怎么知道获取相应数据的key是什么呢？ 有的key是table.name形式的，有的不是！

我测试的代码:

import MySQLdbimport MySQLdb.cursorscon = MySQLdb.connect(user = "root", passwd = "123456", db = "mydb", cursorclass=MySQLdb.cursors.DictCursor)cur = con.cursor()cur.execute("select * from user, post where user.user_id = post.user_id")print cur.fetchone().keys()

编橙之家文章，