Mysql数据库批量更新表编码及排序规则

SELECT
?? ?CONCAT( 'ALTER TABLE ', TABLE_NAME, ' DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;' ) AS '修正SQL'?
FROM
?? ?information_schema.`TABLES`?
WHERE
?? ?TABLE_COLLATION != 'utf8mb4_unicode_ci'?
?? ?AND TABLE_SCHEMA = 'edu-integrated';
?? ?
?? ?
SELECT
?? ?CONCAT( 'ALTER TABLE ', TABLE_NAME, ' MODIFY COLUMN `', COLUMN_NAME, '` ', COLUMN_TYPE, ' CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;' ) AS '修正SQL'?
FROM
?? ?information_schema.`COLUMNS`?
WHERE
?? ?( CHARACTER_SET_NAME != 'utf8mb4' OR COLLATION_NAME != 'utf8mb4_unicode_ci' )?
?? ?AND TABLE_NAME NOT LIKE 'v_%'?
?? ?AND TABLE_SCHEMA = 'edu-integrated';