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 15:47:23