Skip to content

Instantly share code, notes, and snippets.

@jeffreyroberts

jeffreyroberts/mysql_count_rows_in_db.sql

Last active December 23, 2015 05:49
Show Gist options
  • Save jeffreyroberts/6590042 to your computer and use it in GitHub Desktop.
Save jeffreyroberts/6590042 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL - Calculate total rows of all tables in a database
Raw
mysql_count_rows_in_db.sql
SELECT SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '<database_name>';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment