Re: last_insert_id

[Gary Smith]

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?

Gary