mysql character set 변경

-- db 확인

SELECT default_character_set_name FROM information_schema.SCHEMATA S WHERE schema_name = (select database());

-- table 확인

SELECT T.table_name, CCSA.character_set_name FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = (SELECT DATABASE()) AND T.TABLE_TYPE="BASE TABLE";

-- db 변경

ALTER DATABASE superset CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- table 변경

ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

-- table 변경 쿼리 생성

SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;') AS '-- mysql'

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_SCHEMA= (SELECT DATABASE())

AND TABLE_TYPE="BASE TABLE";