Skip to content

Instantly share code, notes, and snippets.

@nd3w

nd3w/gist:dde9fa08b51b3b64c23c30c16038c125

Created August 3, 2019 09:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nd3w/dde9fa08b51b3b64c23c30c16038c125 to your computer and use it in GitHub Desktop.
Save nd3w/dde9fa08b51b3b64c23c30c16038c125 to your computer and use it in GitHub Desktop.
Download ZIP
Important query for MySQL
Raw
gistfile1.txt
Get how many rows in whole database
SELECT SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'db_name';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment