On Sat, 2006-10-28 at 05:44 +0300, George-Cristian Bîrzan wrote:
> On Saturday 28 October 2006 05:34, Ow Mun Heng wrote:
> > Hi,
> >
> > just wondering if there a quick way to determine the # of rows in a
> > mysql table.
> >
> > I know I can do a count(*) but that would entail a table scan etc.
> >
> > I found out that I can do the query into the information_schema table,
> > however, I don't get a consistent reading.
> > executing it multiple times, I get multiple numbers. (and no, the table
> > is static already, no updates/deletes etc)
>
> That's a guesstimate if using InnoDB. Works for MyISAM...
I'm using InnoDB, Thanks for the info then.
>
