[MySQL] Alter charset of all tables and their columns

alter_tables_charset.sql

-- Query to convert table and all its column type to utf8
ALTER TABLE <Table_Name> CONVERT TO CHARACTER SET utf8;

-- Query to generate Alter Table for all tables
SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA, '.', TABLE_NAME," CONVERT TO CHARACTER SET utf8;") AS ExecuteTheString
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA="<Database_Name>"
AND TABLE_TYPE="BASE TABLE";