Here is simple mysql syntax to show tables with row counts :
1 | select table_name, table_rows from information_schema.tables where table_schema = "YOUR_DATABASE_HERE"; |
Here is simple mysql syntax to show tables with row counts :
1 | select table_name, table_rows from information_schema.tables where table_schema = "YOUR_DATABASE_HERE"; |