Last active
February 8, 2020 23:24
-
-
Save felipsmartins/26dd4e6b1793b0f6e39ac9c869af8a7e to your computer and use it in GitHub Desktop.
total_row_count_from_database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'MY_DATABASE_NAME'; | |
SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'MY_DATABASE_NAME' order by table_rows; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment