From: Martin Ramsch
Date: July 5 1999 5:33pm
Subject: Re: MySQL 3.23 & autoincrement
List-Archive: http://lists.mysql.com/mysql/6575
Message-Id: <19990705193316.A23983@forwiss.uni-passau.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Mo, 1999-07-05 12:13:35 -0500, Paul DuBois wrote:
> 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:

Please, would you try "DELETE from t where i>0" instead of "DELETE
from t"?  If I remember correctly the latter actually drops and
recreates the whole table instead of just deleting the records.

Ciao,
  Martin