Re: Auto_Increment and the DELETE Statement

2002-01-07 Thread Paul DuBois
At 16:52 -0600 1/7/02, Rick Emery wrote: >I don't know if this is a bug or a feature. Just an observation concerning >creating MYISAM tables with auto_increment. > >CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000; >INSERT INTO mytable VALUES(NULL); >INSERT INTO mytable

Auto_Increment and the DELETE Statement

2002-01-07 Thread Rick Emery
I don't know if this is a bug or a feature. Just an observation concerning creating MYISAM tables with auto_increment. CREATE TABLE mytable (myval int auto_increment unique ) AUTO_INCREMENT=9000; INSERT INTO mytable VALUES(NULL); INSERT INTO mytable VALUES(NULL); these above INSERTS create entr