Hi, I've got a very large table set up and have defined the id as auto_increment. No rows have been added, deleted, or replaced since the initial load so I'd expect the row count to equal the max(id) since
mysql> describe fidcid; +--------+-----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+-----------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | fId | smallint(5) unsigned | NO | MUL | | | | cId | mediumint(8) unsigned | NO | MUL | | | | ring | tinyint(3) unsigned | NO | | | | +--------+-----------------------+------+-----+---------+----------------+ 4 rows in set (0.38 sec) But this is not the case, as seen below: mysql> select count(*) from fidcid; +-----------+ | count(*) | +-----------+ | 100480507 | +-----------+ 1 row in set (0.09 sec) mysql> select max(id) from fidcid; +-----------+ | max(id) | +-----------+ | 100537311 | +-----------+ 1 row in set (0.22 sec) mysql> Any ideas on what might've happened to explain this? Marty -- Web Installed Formmail - http://face2interface.com/formINSTal/ Webmaster's BBS - http://bbs.face2interface.com/
