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 vote270 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote256 views1 answer
What is the essence of SQL?
SQL
4 votes271 views2 answers
Mysql show indexes on table
SQL
3 votes260 views3 answers
Mysqldump: couldn
SQL
0 vote281 views2 answers
How to display enum value sql server
SQL
1 vote270 views1 answer
Mysql show table character set
SQL
12 votes279 views6 answers
Select distinct
SQL
0 vote295 views1 answer
Consulta alias con inner join
SQL
11 votes291 views5 answers
Sql server reset identity
SQL
4 votes275 views2 answers
Mysql how to change default charset
SQL