Skip to content

Instantly share code, notes, and snippets.

@jeffreyroberts

jeffreyroberts/mysql_count_rows_for_each_table_in_db.sql

Last active December 23, 2015 05:49
Show Gist options
  • Save jeffreyroberts/6590037 to your computer and use it in GitHub Desktop.
Save jeffreyroberts/6590037 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL - Count all rows per table in a database
Raw
mysql_count_rows_for_each_table_in_db.sql
SELECT TABLE_NAME, TABLE_ROWS FROM `information_schema`.`tables` WHERE `table_schema` = '<database_name>';
@jeffreyroberts
Copy link
Author

Output Example:

+-------------------------------------+------------+
| TABLE_NAME                          | TABLE_ROWS |
+-------------------------------------+------------+
| asn_assignee                        |     152965 |
| asn_assignees                       |      31475 |
| asn_assignment                      |      31475 |
| asn_assignment_entry                |      31475 |

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment