I have table with 83,065 rows. Each time I go to MySQL Administrator and look at the catalogs, the number of Rows reported by the administrator changes. I can keep clicking refresh and the number of rows fluctuates between roughly 81,000 and 86,000. I also see similar behavior when I access the table through PHPMyAdmin in browse mode. The crazy part is, this is a static table. I am 100% positive the table is not being inserted to or deleted from.
Here is the create statement for my table. Can anybody offer any insight? CREATE TABLE MyTable (Category varchar(100), Sub_Category varchar(100), Part_Number varchar(40), Description varchar(100), Service_Category varchar(10), Price integer, INDEX(Part_Number(10))) type=InnoDB; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
