Is there a way to get the count of rows in all tables in a MySQL database without running a SELECT count()
on each table?
Mysql – Get record counts for all tables in MySQL database
MySQLrowcountsql
Related Topic
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Sql – Get list of all tables in Oracle
- Mysql – concatenate multiple MySQL rows into one field
- Mysql – Retrieving the last record in each group – MySQL
- Sql – What are the options for storing hierarchical data in a relational database
- Mysql – How to get the sizes of the tables of a MySQL database
- Mysql – How to import an SQL file using the command line in MySQL
Best Answer
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).