Get record counts for all tables in MySQL database

Question

Get record counts for all tables in MySQL database

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?

rowcount sql mysql

3 years ago by Amit8z4mc

2 Answers

Login / Signup to Answer the Question.

Login Signup

**rahul07** · Answer 1 · 2021-08-05T12:47:05

rahul07



SELECT SUM(TABLE_ROWS) 

     FROM INFORMATION_SCHEMA.TABLES 

     WHERE TABLE_SCHEMA = '{your_db}';

3 years ago

**sandhya6gczb** · Answer 2 · 2021-08-09T06:15:58

I just run:

show table status;
This will give you the row count for EVERY table plus a bunch of other info. I used to use the selected answer above, but this is much easier.

I'm not sure if this works with all versions, but I'm using 5.5 with InnoDB engine.

C TUTORIAL

C PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

C++ TUTORIAL

C++ PROGRAMS

INTERVIEW TESTS

EXECUTE CODE

PYTHON TUTORIAL

PYTHON HOW TOS

INTERVIEW TESTS

EXECUTE CODE

JAVA TUTORIAL

JAVA CODE EXAMPLES

SPRING TUTORIAL

MORE IN JAVA

COMPUTER ARCHITECTURE

COMPUTER NETWORK

OPERATING SYSTEM

DBMS & SQL

PL/SQL

MongoDB

EXECUTE SQL

ANDROID DEVELOPMENT

GO LANGUAGE

LINUX

DOCKER

HTML TAGS (A to Z)

CSS REFERENCES

SASS/SCSS

KOTLIN

GAME DEVELOPMENT

PHP

GIT GUIDE

JAVASCRIPT

ADVANCED DSA

Get record counts for all tables in MySQL database

2 Answers

Login / Signup to Answer the Question.