Simple MySQL command to show tables and row counts

Simple MySQL command to show tables and row counts

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";

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.