If your table is MyISAM, then
SELECT COUNT(*) FROM tablename
Will return a rowcount without a major performance hit as the rowcount
is stored and a table scan is not needed.
Regards,
Mike Hillyer
www.vbmysql.com
> -----Original Message-----
> From: Roy W [mailto:php@stripped]
> Sent: Wednesday, July 02, 2003 9:57 AM
> To: mysql@stripped
> Subject: Count Rows?
>
>
> Is there a simple MySQL command that will give a Row Count (#
> of records)
> WITHOUT running a select (huge database)
>
> Thanks!
>
> Roy
>
>
