List:General Discussion« Previous MessageNext Message »
From:Gary Smith Date:December 27 2009 7:26pm
Subject:Re: last_insert_id
View as plain text  
Steve Edberg wrote:
> (2) autoincrement values are not reused after deletion, so if you 
> deleted the record with ID=1000 inserted in (1), the next 
> autoincrement would still be 1001, even if the existing records are 
> IDs 1,2,3. This is usually the desired behavior, but again, may not be 
> what *you* need.
Aah... I'd mis-remembered on this. Is there an SQL mode or somesuch 
which changes this behaviour, or is my mind dribbling out of my ears?

last_insert_idVictor Subervi27 Dec
  • Re: last_insert_idMattia Merzi27 Dec
    • Re: last_insert_idVictor Subervi27 Dec
      • Re: last_insert_idMichael Dykman27 Dec
        • Re: last_insert_idVictor Subervi27 Dec
          • Re: last_insert_idGary Smith27 Dec
            • Re: last_insert_idVictor Subervi27 Dec
            • Re: last_insert_idCarsten Pedersen27 Dec
  • Re: last_insert_idSteve Edberg27 Dec
    • Re: last_insert_idGary Smith27 Dec
      • Re: last_insert_idMark Goodge27 Dec