Get record counts for all tables in MySQL database

by 
SELECT SUM(TABLE_ROWS) 
     FROM INFORMATION_SCHEMA.TABLES 
     WHERE TABLE_SCHEMA = '{your_db}';

Note from the docs though: For InnoDB tables, the row count is only a rough estimate used in SQL optimization. You’ll need to use COUNT(*) for exact counts (which is more expensive).

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. Create a Cumulative Sum Column in MySQL
  3. Equivalent of explode() to work with strings in MySQL
  4. How can I tell when a MySQL table was last updated?
  5. MySQL Trigger after update only if row has changed
  6. MySQL “WITH” clause
  7. mysql select dynamic row values as column names, another column as value
  8. MySQL “Group By” and “Order By”
  9. Illegal mix of collations MySQL Error
  10. SQL query: Delete all records from the table except latest N?
  11. SQL order string as number
  12. Find most frequent value in SQL column
  13. How to convert number of week into date?
  14. update multiple rows using limit in mysql?
  15. Mysql 1050 Error “Table already exists” when in fact, it does not
  16. How to get the latest record in each group using GROUP BY? [duplicate]
  17. SQL Query to get column values that correspond with MAX value of another column?
  18. MySQL : transaction within a stored procedure
  19. When to use SELECT … FOR UPDATE?
  20. Setting column values as column names in the SQL query result
  21. How do I UPDATE a row in a table or INSERT it if it doesn’t exist?
  22. SQL unique varchar case sensitivity question
  23. How to get current date & time in MySQL?
  24. How do I count columns of a table
  25. Laravel join with 3 Tables
  26. How to regex in a MySQL query
  27. MySQL 5.6 – DENSE_RANK like functionality without Order By
  28. Syntax error on MERGE statement
  29. INSERT INTO Table from multiple tables
  30. Mysql How do you create a clustered index?

Leave a Comment