Re: reusing auto-increment values

Hi Martin What about using a REPLACE or UPDATE rather than a DELETE/INSERT? Peter. On 20 May 2002, Martin Skjöldebrand wrote: > Hi, > > It's kind of embarrasing this, but ... > How do I resuse autoincremented values after a delete? Do I specify it > in the table somehow? > > Like _not_ havin

reusing auto-increment values

Hi, It's kind of embarrasing this, but ... How do I resuse autoincremented values after a delete? Do I specify it in the table somehow? Like _not_ having table 1 cat 2 dog 4 zebra 9 elephant after a few deleted animals. Preferably 1 cat 2 dog 3 zebra