Some more information can be found here:
http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html
On 12/31/05 7:29 PM, "JJ" <[EMAIL PROTECTED]> wrote:
> I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest
> why MySQL Adminstrator says the table has 497 rows, while do
- Original Message -
> I have an InnoDB table in a MySQL 4.1.14 database. Can anyone suggest
> why MySQL Adminstrator says the table has 497 rows, while doing a query
> or a count on the same table shows that it only has 434?
>
IIRC, InnoDB only gives an estimated row count in admin
