select CONCAT('alter table ', TABLE_SCHEMA, '.', TABLE_NAME, ' CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') from information_schema.TABLES WHERE TABLE_SCHEMA='daishu';
select CONCAT('alter table ', TABLE_SCHEMA, '.', TABLE_NAME, ' change ', COLUMN_NAME, ' ', COLUMN_NAME, ' ', COLUMN_TYPE, ' CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;') from information_schema.COLUMNS WHERE TABLE_SCHEMA='daishu' and DATA_TYPE='varchar';
修改mysql所有列的CHARACTER SET(修改列的其他信息可以同样处理)
最新推荐文章于 2022-11-28 17:38:48 发布