How to count number of record in mysql ?

[Jai]

Hello Sir, I m just learning mysql and i have a project of mysql in which i create a table b't now m stuck at a point and can't proceed ahead. I want to know the number of record ? So, can u just tell me what command i should use for it ?

[Jaffery]

That is kind of easy .

Simply run query : SELECT COUNT(*) FROM 'tablenamehere' ;