SELECT
CONCAT(“ALTER TABLE `”, TABLE_NAME,”` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;”)
AS target_tables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=”db_name”
AND TABLE_TYPE=”BASE TABLE”
SELECT
CONCAT(“ALTER TABLE `”, TABLE_NAME,”` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;”)
AS target_tables
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=”db_name”
AND TABLE_TYPE=”BASE TABLE”