jules0x/query.sql

Last active June 21, 2023 21:36

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/jules0x/098d6a583a3c5ddbc0e157128eeb83c7.js"></script>
Save jules0x/098d6a583a3c5ddbc0e157128eeb83c7 to your computer and use it in GitHub Desktop.

Download ZIP

SQL: Query row count for all tables in DB

Raw

	SELECT table_name, table_rows
	FROM INFORMATION_SCHEMA.TABLES
	WHERE TABLE_SCHEMA = 'db_name'
	ORDER BY table_rows desc;

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