Simple MySQL command to show tables and row counts
Here is simple mysql syntax to show tables with row counts : 1select 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 : 1select table_name, table_rows from information_schema.tables where table_schema = "YOUR_DATABASE_HERE";