取出mysql中的emoji表情

-- 修改数据库字符集
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;

-- 使用前缀索引
ALTER TABLE your_table_name ADD INDEX idx_prefix (your_column_name(191));

-- 创建表
CREATE TABLE emoji_test (
    id INT AUTO_INCREMENT PRIMARY KEY,
    content TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 插入包含Emoji表情的数据
INSERT INTO emoji_test (content) VALUES ('Hello 😊 World!');

-- 查询数据
SELECT * FROM emoji_test;