List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:July 5 1999 5:33pm
Subject:Re: MySQL 3.23 & autoincrement
View as plain text  
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
Thread
SQL join questionWillem Bison11 Mar
  • Re: SQL join questionChristian Mack11 Mar
  • Re: MySQL 3.23 alpha released (problems/fixes)Paul DuBois5 Jul
    • MySQL 3.23 & autoincrementBarry5 Jul
      • Re: MySQL 3.23 & autoincrementPaul DuBois5 Jul
        • Re: MySQL 3.23 & autoincrementMartin Ramsch5 Jul
          • Re: MySQL 3.23 & autoincrementPaul DuBois5 Jul
            • Re: MySQL 3.23 & autoincrementMichael Widenius7 Jul
        • Re: MySQL 3.23 & autoincrementDick Griffin5 Jul
        • Re: MySQL 3.23 & autoincrementMichael Widenius7 Jul
      • MySQL 3.23 & autoincrementMichael Widenius7 Jul