Re: Row Count Discrepency

2006-01-01 Thread Terry Riley
- 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

Re: Row Count Discrepency

2006-01-01 Thread William Allaire
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 doing a

Row Count Discrepency

2005-12-31 Thread JJ
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? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To