Count all records from your MySQL databse

If you want to count all records from your database, follow below instructions.

1) Login To your database.

2) Execute below query

> SELECT table_name, TABLE_ROWS FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'DATABASE_NAME' order by TABLE_ROWS asc;

You have to change only database_name from above query.