Re: MySQL 3.23 & autoincrement

[Martin Ramsch]

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