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:[EMAIL PROTECTED] > Sent: Wednesday, July 02, 2003 9:57 AM > To: [EMAIL PROTECTED] > 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 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]