Home >Database >Mysql Tutorial >Can we get the total row count of MySQL database?

Can we get the total row count of MySQL database?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBforward
2023-09-13 17:37:071440browse

我们可以获得 MySQL 数据库的总行数吗?

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!

Statement:
This article is reproduced at:tutorialspoint.com. If there is any infringement, please contact admin@php.cn delete
Previous article:Search two keys in MySQLNext article:Search two keys in MySQL