Change db tables and columns charset quickly - Veritabanı tablo ve kolonlar karakter setini hızlı değiştir

db-change-character-set-quickly.sql

SELECT CONCAT('ALTER TABLE ',TABLE_SCHEMA,'.',TABLE_NAME,' CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;')
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = 'db_name';

# Example Output - Örnek Çıktı: 
# ALTER TABLE db_name.table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;