To return the number of rows in a table, type the following command:
mysql> select count(*) from
[table_name];
Examples
The following example shows the basic use of this command:
mysql> select count(*) from
employees;
To return the number of rows in a table, type the following command:
mysql> select count(*) from
[table_name];
The following example shows the basic use of this command:
mysql> select count(*) from
employees;