[MySQL CONVERT CHARACTER SET to utf8 for all tables] Generate query for convert character set to utf8 for all tables #mysql #characterset

generate_convert_query.sql

SELECT CONCAT("ALTER TABLE `", TABLE_NAME,"` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;")  AS    ExecuteTheString
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="[YOUR DATABASE NAME]"
AND TABLE_TYPE="BASE TABLE";

SELECT @@character_set_database, @@collation_database;