Python3：查询MYSQL并以字典接收

cursor这里有个属性：description。获取的是数据库每个栏位（字段，列）情况： (('id', 3, None, 11, 11, 0, False), ('type', 253, None, 5, 5, 0, False) 

result_dict = dict(zip([col[0] for col in cursor.description],[col for col in cursor.fetchone()]))
           

查询结果有多个记录，获取最后一条记录并以字典返回：

result_dict = dict(zip([col[0] for col in cursor.description],[col for col in cursor.fetchall()[-1]]))