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

1 vote203 views1 answer
Backup mysql data only
SQL
1 vote211 views1 answer
Blob datatype in mysql
SQL
3 votes203 views1 answer
Locate sql server
SQL
0 vote298 views1 answer
Example database query
SQL
0 vote201 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
0 vote264 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote214 views1 answer
Sql examples from framework
SQL
0 vote219 views2 answers
Postgres show current role
SQL
16 votes209 views4 answers
Mysql import from sql file
SQL
0 vote211 views1 answer
Postgres in operator with comma separated values
SQL