正常修改语句:
alter table 表 convert to character set utf8mb4 collate utf8mb4_bin;
获取所有修改表的语句:
select CONCAT('alter table ',a.table_name,' convert to character set utf8mb4 collate utf8mb4_bin;') from (select table_name from information_schema.`TABLES` where TABLE_SCHEMA = '数据库名') a;
如图:
然后复制出来,批量执行