Re: Dealing with auto-increment in MySQL

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. 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?

Don't touch the deleted id's. You don't need them. If you re-order your id's, you're creating havoc (think of table "b" referencing the first table - all the id's are screwed up there too). What problem are you trying to solve? -- Postgresql & php tutorials http://www.designmagick.com/