python查询mysql数据库乱码

SHOW CREATE DATABASE your_database_name;
SHOW CREATE TABLE your_table_name;

import pymysql

# 连接数据库时指定字符集
db = pymysql.connect(host='your_host', user='your_username', password='your_password', db='your_database', charset='utf8mb4')

# 执行查询操作
cursor = db.cursor()
cursor.execute('SELECT * FROM your_table')
results = cursor.fetchall()

# 处理查询结果
for row in results:
    # 处理数据
    pass

# 关闭数据库连接
db.close()

import pymysql

# 连接数据库
db = pymysql.connect(host='your_host', user='your_username', password='your_password', db='your_database')

# 设置会话字符集
cursor = db.cursor()
cursor.execute('SET NAMES utf8mb4')

# 执行查询操作
cursor.execute('SELECT * FROM your_table')
results = cursor.fetchall()

# 处理查询结果
for row in results:
    # 处理数据
    pass

# 关闭数据库连接
db.close()