Can we get the total row count of MySQL database?

To get the total number of rows in a MySQL database, you can use aggregate function SUM() along with inbuilt column TABLE_ROWS from INFORMATION_SCHEMA.TABLES.

The syntax is as follows−

SELECT SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = database();

Suppose we are using a database named 'sample'.

Now we will get the total number of rows in the MySQL database−

mysql> SELECT SUM(TABLE_ROWS)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = database();

This will produce the following output−

+-----------------+
| SUM(TABLE_ROWS) |
+-----------------+
| 2043            |
+-----------------+
1 row in set (22.11 sec)

The above is the detailed content of Can we get the total row count of MySQL database?. For more information, please follow other related articles on the PHP Chinese website!