Counting MySQL tables from the shell

Submitted by Frederic Marand on
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