Skip to content

Instantly share code, notes, and snippets.

@madalinignisca

madalinignisca/count_db_rows.sql

Created April 23, 2017 09:41
Show Gist options
  • Save madalinignisca/f7e585138724d126b4be9e7457e64893 to your computer and use it in GitHub Desktop.
Save madalinignisca/f7e585138724d126b4be9e7457e64893 to your computer and use it in GitHub Desktop.
Download ZIP
Count ROWS total in a MySQL Database
Raw
count_db_rows.sql
SELECT SUM(TABLE_ROWS) FROM `information_schema`.`tables` WHERE `table_schema` = 'your_database_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment