需修改的地方汇总如下:
alter table [具体emoji表名] convert to character set utf8mb4;
set character_set_client='utf8mb4';
set character_set_connection='utf8mb4';
set character_set_database='utf8mb4';
set character_set_results='utf8mb4';
set character_set_server='utf8mb4';
set character_set_system='utf8mb4'