插入mysql数据库乱码

-- 设置数据库字符集
ALTER DATABASE your_database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 设置表字符集
ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 设置列字符集
ALTER TABLE your_table_name MODIFY your_column_name VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

mysql -u your_username -p --default-character-set=utf8mb4

import pymysql

conn = pymysql.connect(
    host='your_host',
    user='your_username',
    password='your_password',
    db='your_database',
    charset='utf8mb4'
)

cursor.execute("INSERT INTO your_table_name (your_column_name) VALUES (%s)", (your_data,))