From: Paul DuBois
Date: July 5 1999 5:13pm
Subject: Re: MySQL 3.23 & autoincrement
List-Archive: http://lists.mysql.com/mysql/6574
Message-Id: <v04020a2cb3a69787d632@[192.168.0.6]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

At 12:41 PM -0400 7/5/1999, Barry wrote:
>Hello All,
>
>I just downloaded the WinNT 3.22.24 and was looking through the new manual
>at the Changes in 3.22.24 section. I came upon the following statement
>about the MyISAM tables planned for 3.23.x.
>
>"Internal handling of one AUTO_INCREMENT column. MyISAM will automatically
>update this on INSERT/UPDATE. The AUTO_INCREMENT value can be reset with
>myisamchk. This will make AUTO_INCREMENT columns faster and old numbers
>will not be reused."
>
>I am happy to see that old numbers will not be re-used, but am I
>miss-reading this? Will an Update on an existing row modify the
>Auto_Increment value? Using an Auto_Increment value as a static db record
>identifier, I would not want this value to be modified once the row is
>Inserted.

You're probably thinking of TIMESTAMP.  AUTO_INCREMENT isn't like that.

By the way, the no-reuse property doesn't seem to be implemented yet.
Try this:

USE test
DROP TABLE IF EXISTS t;
CREATE TABLE t (i INT AUTO_INCREMENT PRIMARY KEY);
INSERT t VALUES(NULL),(NULL);
SELECT * FROM t;
DELETE FROM t;
INSERT t VALUES(NULL),(NULL);
SELECT * FROM t;

I get the same result from both SELECT statements:

+---+
| i |
+---+
| 1 |
| 2 |
+---+

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/