Command line mysql for row counts for all tables in a database

NB count is approximate for innodb tables

1

SELECT table_name, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{your_db}';