ophe DIARRA" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, December 13, 2002 9:38 PM
Subject: Fastest way to get the number of rows in a table ?
> Hi.
>
> I need to know the number of rows in a table.
>
> "select count(*) fro
The numbers reported by SHOW TABLE STATUS in the case
of an InnoDb table are *approximate*, not the real
count.
"Note that the statistics SHOW gives about InnoDB
tables are only approximate: they are used in SQL
optimization. Table and index reserved sizes in bytes
are accurate, though. "
See s
Hi.
I need to know the number of rows in a table.
"select count(*) from a_table" works fine but it is slow when the table
is big.
I am trying instead "show table status like 'a_table'". The column 'Rows'
should give me the number of rows in the table 'a_table'. This works fine
for most of the ta
