Count MySQL Rows

How to count MySQL Table rows using select query?


Count MySQL Rows :

COUNT(*) counts the number of rows in a table.

Syntax :

SELECT COUNT(*) from tbl_name;
Lets see the counting mysql rows using select statement.

Example :

Count MySQL Rows
This Example shows how to count MySQL Rows. The above query will list the number of rows in the student table.

Ask Questions

Ask Question