How to convert all Database Tables and Columns to a specific Collation.

convert.sql

# 1.Convert the Collation of a Database
ALTER DATABASE DBNAME CHARACTER SET utf8 COLLATE utf8_general_ci;
# 2.Convert the Collation of all Tables
SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA, '.', TABLE_NAME,' COLLATE utf8_general_ci;')
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='DBNAME' AND TABLE_TYPE = 'BASE TABLE';
# 3.Convert the Collation of Table Columns
SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;') AS    mySQL
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= "DBNAME" AND TABLE_TYPE="BASE TABLE"