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 TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

import pymysql

connection = pymysql.connect(
    host='your_host',
    user='your_user',
    password='your_password',
    db='your_database',
    charset='utf8mb4',  # 确保这里设置为utf8mb4
    cursorclass=pymysql.cursors.DictCursor
)

import pymysql

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

try:
    with connection.cursor() as cursor:
        # 创建表
        sql = """
        CREATE TABLE IF NOT EXISTS `emojis` (
            `id` INT AUTO_INCREMENT PRIMARY KEY,
            `content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
        )
        """
        cursor.execute(sql)

        # 插入表情符号
        sql = "INSERT INTO `emojis` (`content`) VALUES (%s)"
        cursor.execute(sql, ('😊🌍🚀',))

        # 提交事务
        connection.commit()

        # 查询表情符号
        sql = "SELECT * FROM `emojis` WHERE `id`=%s"
        cursor.execute(sql, (1,))
        result = cursor.fetchone()
        print(result)

finally:
    connection.close()