MySQL Commands

  • Check all table collations and charset using join 
    mariadb -e "
SELECT 
  t.TABLE_NAME,
  t.TABLE_COLLATION,
  c.CHARACTER_SET_NAME AS TABLE_CHARSET
FROM information_schema.TABLES t
LEFT JOIN information_schema.COLLATIONS c
  ON t.TABLE_COLLATION = c.COLLATION_NAME
WHERE t.TABLE_SCHEMA = 'YourDatabaseName'
ORDER BY t.TABLE_NAME;
"
  • Checking only collation 
    mariadb -e "
SELECT TABLE_NAME, TABLE_COLLATION
FROM information_schema.TABLES
WHERE TABLE_SCHEMA='YourDatabaseName'
ORDER BY TABLE_NAME;
"