SET foreign_key_checks = 0; SELECT CONCAT('alter table ',TABLE_SCHEMA,'.',TABLE_NAME,'charset=utf8mb4;') from information_schema.TABLES WHERE TABLE_SCHEMA = 'ghost'; select CONCAT('alter table', TABLE_SCHEMA, '.', TABLE_NAME,' alter column ',COLUMN_NAME,' charset=utf8mb4;') from information_schema.COLUMNS WHERE TABLE_SCHEMA = 'ghost'; SET foreign_key_checks = 1;