python连接MySQL获取表中数据

本人博客一律不收费，全部粉丝可看。如对您有用，帮忙关注微信公众号“趣聊天地”，关注点赞，不胜感激。

import pymysql

# 连接数据库
conn = pymysql.connect(
    host='localhost',
    user='root',
    password='root',
    db='test',
    charset='utf8mb4',
    cursorclass=pymysql.cursors.DictCursor
)

def data_upload(key, value):
    # print(f"Key:{key},Value:{value}")
    print(f"{key},{value}")

try:
    # 创建游标对象
    with conn.cursor() as cursor:
        # 执行查询语句
        sql = "SELECT * FROM student WHERE id = %s"
        cursor.execute(sql, ('88',))

        # 获取查询结果
        result = cursor.fetchone()

        # 输出查询结果
        print(result)
        print(type(result))

        if result is not None and isinstance(result, dict):
            for key, value in result.items():
                data_upload(key, value)
        else:
            print("dict is null")

finally:
    # 关闭数据库连接
    conn.close()