How can we use MySQL SELECT statement to count number of rows in a table?

We need to use COUNT(*) function with SELECT clause to count the total number of rows in a table.

Example

mysql> Select COUNT(*) from Student;

+----------+
| COUNT(*) |
+----------+
| 4        |
+----------+

1 row in set (0.06 sec)

The query above counts the total number of rows of ‘Student’ table.

We can also use WHERE clause with COUNT(*) function as follows:

mysql> Select COUNT(*) from Student where Address = 'Delhi';

+----------+
| COUNT(*) |
+----------+
| 2        |
+----------+

1 row in set (0.00 sec)

Paul Richard

Published on 19-Feb-2018 11:17:23

• Related Questions & Answers
• Can we use SELECT NULL statement in a MySQL query?
• How can we use SET statement to assign a SELECT result to a MySQL user variable?
• Count number of rows in each table in MySQL?
• How can we count a number of unique values in a column in MySQL table?
• Fastest way to count number of rows in MySQL table?
• How can we delete multiple rows from a MySQL table?
• How can we delete all rows from a MySQL table?
• How can we use a MySQL subquery with INSERT statement?
• How to count number of rows in a table with jQuery?
• How to get number of rows in a table without using count(*) MySQL query?
• How to use NULL in MySQL SELECT statement?
• How can we use SIGNAL statement with MySQL triggers?
• How can I use MySQL IF() function within SELECT statement?
• Can we get total number of rows in a MySQL database?
• Can we use {} while creating a MySQL table?