批量修改mysql数据库的编码 utf8mb4

1.修改数据库的编码 utf8mb4

ALTER DATABASE fecpx  CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER DATABASE fecpx  DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

2.修改边的编码为 utf8mb4

ALTER TABLE fecpx_addons CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; 

3.数据库所有表的编码批量修改

SELECT
    CONCAT(
        'ALTER TABLE ',
        TABLE_NAME,
        ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;'
    )
FROM
    information_schema.`TABLES`
WHERE
    TABLE_SCHEMA = '数据库名称';  // 将文字替换为数据库名称

执行后会生成很多的sql语句，譬如：

ALTER TABLE `fecpx_addons_language_product_collection` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `fecpx_addons_language_product_options_unique` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `fecpx_addons_notice_email_theme` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

粘贴到mysql中执行即可