Skip to content

Instantly share code, notes, and snippets.

@toddsiegel

toddsiegel/mysql_admin.sql

Created February 14, 2018 18:43
Show Gist options
  • Save toddsiegel/e4277b0ae133f64f47f3a275080e0fe6 to your computer and use it in GitHub Desktop.
Save toddsiegel/e4277b0ae133f64f47f3a275080e0fe6 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL Admin Queries
Raw
mysql_admin.sql
SELECT t.table_name, ccsa.character_set_name
FROM information_schema.tables t
JOIN information_schema.collation_character_set_applicability ccsa
ON ccsa.collation_name = t.table_collation
WHERE t.table_schema = '<schema_name>'
ORDER BY t.table_name
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment