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 vote198 views1 answer
Sqlite3 update select
SQL
15 votes246 views4 answers
Export mysql db using command line
SQL
0 vote170 views1 answer
Zerar auto increment mysql
SQL
1 vote253 views1 answer
Pgsql sum switch case
SQL
0 vote201 views1 answer
Microsoft word insert sql code
SQL
103 votes2.4K views1 answer
Like sql
SQL
-1 vote242 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote189 views1 answer
Left join vs inner join performance
SQL
2 votes252 views3 answers
3 days back in sql server
SQL
1 vote194 views1 answer
Wordpress change http to https phpmyadmin
SQL