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.
>
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,
> howe
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