Count function in mysql

counting the number of records in a table.

Example:

Select * from mydoubts_table;

————————————
|firstname | lastname | address |
————————————
|vasanthan | pv | india |
|nazar | gt | texas |
|raju | raina | sreelanka|
|gt | nazar | texas |
|Martin | jacob | Dubai |
|mydoubts.in | | newyork |
|wordsgallery| | Frankfurt|
————————————-

Select COUNT(*) from mydoubts_table;

————
| COUNT(*) |
————
| 7 |
————

Select COUNT(*) from mydoubts_table where firstname=’vasanthan’;

————
| COUNT(*) |
————
| 1 |
————