Counting MySQL tables from the shell

Submitted by Frederic Marand on Tue, 2011-07-05 15:12
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