I have been trying out 4.1.3 beta on XP, and note that in SQLyog, Maestro, and even MYSQL Administrator, the number of records shown is always one more than actual - in InnoDB tables only. Even an empty table still shows as 1. This is different than the count shown in these GUIs with 4.1.1 alpha.
SELECT COUNT(*) retrieves the correct number, however. This is not the case for the MyISAM tables, which show the correct numbers at all times. Is this supposed to happen? Terry Riley -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]