Skip to content

Instantly share code, notes, and snippets.

@AmmarCodes

AmmarCodes/mysql: Show tables with row count.sql

Created November 21, 2018 12:01
Show Gist options
  • Save AmmarCodes/e0b7aa45c8c98a171a9e59d55d73d71f to your computer and use it in GitHub Desktop.
Save AmmarCodes/e0b7aa45c8c98a171a9e59d55d73d71f to your computer and use it in GitHub Desktop.
Download ZIP
Raw
mysql: Show tables with row count.sql
SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = 'DATEBASE_NAME';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment