MYSQL: How to get the summary of tables in a DB

I sometimes want to see the number of rows in the tables of my DB. Instead of using COUNT for each table, use this command to get the summary of your database.

   mysql> show table status; 

Results: +----------------------------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+ | Name | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Collation | Checksum | Create_options | Comment | +----------------------------------------+--------+---------+------------+-------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+-------------------+----------+----------------+---------+ | account_customer | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 51380224 | 1 | 2012-10-16 12:34:33 | NULL | NULL | latin1_swedish_ci | NULL |