On 12/6/06, Mikhail Berman <[EMAIL PROTECTED]> wrote:
-----Original Message----- > From: Dotan Cohen [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 06, 2006 3:37 PM > To: MySQL General > Subject: How many records in table? > > What's a quick query to determine how many records a given table > contains? > SELECT count(*) from YOUR_TABLE
This will return instantly for MyISAM tables but will have to count rows on InnoDB. -- -jp Chuck Norris frequently donates blood to the Red Cross. Just never his own.
