English
Sign in / Sign up

Count MySQL Rows

How to count MySQL Table rows using select query?

Explanation

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.
PreviousNext

Mysql Tutorial


Ask Questions

Ask Question