Mysql Table rows

Easiest way for me to check how many rows in tables of database is to use the query:

SHOW TABLE STATUS FROM `database_name`

easy.. good luck