Re: MySQL question

No, it's supposed to be like that -- If you have some *OTHER* records cross-referenced to those IDs, you want to be sure they don't end up being linked to the wrong data if an ID were re-used. IDs are never* re-used, you don't want them to be re-used, and you should not attempt to do anything to "fix" this. Actually, if you get to 2 BILLION records, you'll have to worry about IDs getting re-used... -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm ----- Original Message ----- From: Georgie Casey <webmaster@filmfind.tv> Newsgroups: php.general To: <php-general@lists.php.net> Sent: Friday, October 05, 2001 5:14 PM Subject: MySQL question > I have a table set as auto_update for the primary ID field, but sometimes > the PHP script adds fields which don't fill up all of the ID numbers, as I > delete a few records manually. is there any way to ensure all primary id > field nos. are filled up > > is this a potential problem > -- > Regards, > Georgie Casey > webmaster@filmfind.tv > > *************************** > http://www.filmfind.tv > Ireland's Online Film Production Directory > *************************** > >