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