Mysql get all tables row count

Count of tables in database mysql

SELECT count(*) 
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = 'database_name'

Mysql count all table rows

SELECT COUNT(*) FROM count_demos; // Code language: SQL (Structured Query Language) (sql)

Source: mysqltutorial.org

Mysql get all tables row count

# get row count of all tables in all database in this server
select table_name, table_schema,table_rows from information_schema.tables;

# get row count of all tables in testdb database
select table_name, table_schema,table_rows from information_schema.tables where table_schema='testdb';

Mysql count table rows

select table_name, sum(table_rows) as sum 
from information_schema.tables
where table_schema = '[DB NAME]'
group by table_name 
order by sum desc;

Similar codes

0 vote204 views1 answer
How to find symmetric pairs in sql
SQL
12 votes229 views10 answers
Google
SQL
0 vote160 views1 answer
Sql view index
SQL
2 votes205 views1 answer
Pandas to sql index
SQL
0 vote171 views1 answer
Price-colour
SQL
0 vote186 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote172 views1 answer
Mysqldump ignore table
SQL
0 vote183 views1 answer
Select even number id data from table
SQL
3 votes176 views2 answers
Oracle for loop
SQL
0 vote176 views1 answer
Mysql vs sql server performance benchmark
SQL