Skip to content

Instantly share code, notes, and snippets.

@reddyweb

reddyweb/mysql.md

Last active April 25, 2019 12:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save reddyweb/1ac6c1f852edb5661cf6c2361c7917ad to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save reddyweb/1ac6c1f852edb5661cf6c2361c7917ad to your computer and use it in GitHub Desktop.
Download ZIP
find out which table has more records mysql
Raw
mysql.md

Find out number of records of all tables in MySQL datbase

SELECT table_name, table_rows FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'database_name' order by table_rows;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment