MySql8 数据库迁移 Mysql5.7 字符集编码 utf8mb4_0900_ai_ci Mysql5.7不支持

utf8mb4_0900_ai_ci

批量修改字符集编码

SELECT

CONCAT("ALTER TABLE `", TABLE_NAME,"` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;")

AS target_tables

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA="mall"