Skip to content

Instantly share code, notes, and snippets.

@ppazos

ppazos/mysql_table_count.sql

Created March 7, 2024 19:27
Show Gist options
  • Save ppazos/62abc0abdcbcf21815a2cd683e108710 to your computer and use it in GitHub Desktop.
Save ppazos/62abc0abdcbcf21815a2cd683e108710 to your computer and use it in GitHub Desktop.
Download ZIP
Count records for each table in MySQL
Raw
mysql_table_count.sql
SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '__YOUR_DB__';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment