Re: auto_increment field - Nat Bell - com.mysql.lists.win32

6 messages in com.mysql.lists.win32Re: auto_increment field

From	Sent On	Attachments
Joris Lambrecht	23 Feb 2001 08:19
Nat Bell	23 Feb 2001 08:44
Tim Endres	23 Feb 2001 09:44
Tim Endres	23 Feb 2001 13:42
Tim Endres	23 Feb 2001 16:49
Christopher Land	23 Feb 2001 17:13

Subject:	Re: auto_increment field
From:	Nat Bell (na...@bellwebsolutions.com)
Date:	02/23/2001 08:44:45 AM
List:	com.mysql.lists.win32

auto_increment's sole purpose is to create a unique ID; once a record is created and subsequently deleted, so is its auto_increment value. If you re-create the record the auto_increment value goes to the next integer value automatically. This is perfectly normal; you are doing nothing wrong!

Nat

i'm wondering why a deleted record with an auto_increment field is not released for future use.

i use the ID field to index my tables, it's a primary key and auto_increments when i create record 0003, delete it and then create a new record mysql creates record with ID 0004 while 0003 does no longer exist

am i doing something wrong here ?

thanks for any input

joris

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail win3...@lists.mysql.com instead.