DictCursor 字典结果

← 返回 Python3 MySQL 数据库

57.19 DictCursor 字典结果

cursorclass=DictCursor 使每行变为 dict，用 row["name"] 访问列。

字典形式输出

import pymysql
from pymysql.cursors import DictCursor

conn = pymysql.connect(
    host='127.0.0.1', user='root', password='root',
    database='py_demo', charset='utf8mb4',
    cursorclass=DictCursor
)
try:
    with conn.cursor() as cur:
        cur.execute('SELECT name, score, class_name FROM students ORDER BY score DESC LIMIT 5')
        for row in cur.fetchall():
            print(row['name'], row['score'], row['class_name'])
finally:
    conn.close()