Webmaster's Community

Designing and Development => Programming => Topic started by: Jai on September 15, 2011, 01:53:00 PM

Title: How to count number of record in mysql ?
Post by: Jai on September 15, 2011, 01:53:00 PM

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 ?

Title: Re: How to count number of record in mysql ?
Post by: Jaffery on September 16, 2011, 11:06:01 AM

That is kind of easy .

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