SELECT
CONCAT('ALTER TABLE ', table_name, ' MODIFY COLUMN ', column_name, ' ',
COLUMN_TYPE
,
' CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ;')
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_SCHEMA = 'your_database' AND
COLLATION_NAME is not null and COLLATION_NAME !='utf8mb4_general_ci';
mysql统一调整 所有表字段字段字符集
于 2025-03-21 11:33:34 首次发布