On 12/6/06, Mikhail Berman <mberman@ivesinc.com> wrote:
>
> -----Original Message-----
> >
> From: Dotan Cohen [mailto:dotancohen@gmail.com]
> > 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.