Counting MySQL tables from the shell

Submitted by Frederic Marand on
Computing
Tiny tip for the day: a one-liner to get the number of tables on a MySQL server across all databases: 
mysql -BNe 'SELECT COUNT(*) FROM TABLES' information_schema