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_ having > > table > 1 cat > 2 dog > 4 zebra > 9 elephant > > after a few deleted animals. Preferably > > 1 cat > 2 dog > 3 zebra > 4 elephant > 5 snake > etc > > As I said it's embarrasing ... and I didn't even had a bad fall or > anything, and I can't find it on www.mysql.com. > > /M. > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
