Re: Dealing with auto-increment in MySQL

On Mon, Sep 03, 2007 at 11:53:22PM -0400, Steve Finkelstein wrote: > 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. Re-numbering is a bad idea for anything more than a simple database, you risk breaking foreign keys relations. > 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? I can't see that it matters, especially if you use unsigned ints for maximum range. -- Greg Donald Cyberfusion Consulting http://cyberfusionconsulting.com/