I just let it go...there is no need to manage that process or you'll just screw up the mysql... it shouldn't be relied on for anything other that uniqueness any way bastien > Date: Mon, 3 Sep 2007 23:53:22 -0400> From: sf@xxxxxxxxxxxxx> To: php-general@xxxxxxxxxxxxx> Subject: Dealing with auto-increment in MySQL> > How're you folks dealing with records that are auto incremented in MySQL> after a delete is made? I've noticed the only way to get a sequential order> back is to truncate the table completely.> > Do you use logic in your code to find a missing ID and insert new records> based on that? Or do you just ignore it, let mysql handle the numbering and> go on with your lives?> > Just curious.> > Thanks!> > - sf _________________________________________________________________ Connect to the next generation of MSN Messenger http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=wlmailtagline
