python mysql取出字段名和数据(字典)

import pymysql

# mysql链接初始化
# cursorclass 设置这个就可以key-value像php一样显示数据
def mysql_model():
    mysql_content = pymysql.connect(host="你的host", user="用户名",
                                    password="密码",
                                    database="数据库", charset="utf8", port=3306,
                                    cursorclass=pymysql.cursors.DictCursor)
    return mysql_content