Finding how many rows in a table in Mysql?

See the Example

Select * from mydoubts_data

+———+————————-+——————–+
| EMPCODE | NAME | SALARAY CODE |
+———+————————-+——————–+
| 787 | Vasanthan | K |
| GORT | Shaji | S |
| GKL | James | P |
| IND | Abdul | ZO |
| VIS | Sunil | F |
+———+————————-+——————–+

For finding the number of rows in a table use the following quries.

Select count(*) from mydoubts_data

+———-+
| count(*) |
+———-+
| 5 |
+———-+