Re: deleted primary key can't be reused?

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder1.xlned.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Message-ID	<51C492E9.5000403@example.com> (permalink)
Date	Fri, 21 Jun 2013 19:52:41 +0200
From	Marc van Lieshout <invalid@example.com>
User-Agent	Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130509 Thunderbird/17.0.6
MIME-Version	1.0
Newsgroups	comp.lang.php
To	richard <noreply@example.com>
Subject	Re: deleted primary key can't be reused?
References	<1riuk3ca2113p$.1butqaatdq7hw.dlg@40tude.net>
In-Reply-To	<1riuk3ca2113p$.1butqaatdq7hw.dlg@40tude.net>
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
Lines	23
NNTP-Posting-Host	2001:980:4910:1:b41c:34b9:569f:b21c
X-Trace	1371837159 news.xs4all.nl 15901 [2001:980:4910:1:b41c:34b9:569f:b21c]:4169
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.php:9854

Show key headers only | View raw

On 08-06-13 16:24, richard wrote:
> Entered 100 items into 2 columns each.
> Deleted 2.
> Upon entering new record using id of 98, no can do.
> The next new record number becomes 101.
> "Duplicate key error" is issued.
> How do I take back the deleted key number so I can use it again?
> No, I do not mean the data that is in the record.
> To me, once a record is deleted, the key index should reflect that the
> record no longer exists, so the key index should be -1 of what it was.
> Not continue its esistance.
>

This is related to a problem I had once: I wanted a special record in a 
table with id 0.

insert into <table> (id, ...) values (0, ....);

didn't work; the insert was succesful, but with ID 1. Then I executed:

update <table> set id = 0 where id = 1;

That solved the problem.

Back to comp.lang.php | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

deleted primary key can't be reused? richard <noreply@example.com> - 2013-06-08 10:24 -0400
  Re: deleted primary key can't be reused? richard <noreply@example.com> - 2013-06-08 10:57 -0400
  Re: deleted primary key can't be reused? Luuk <luuk@invalid.lan> - 2013-06-08 17:46 +0200
  Re: deleted primary key can't be reused? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-08 18:47 +0100
  Re: deleted primary key can't be reused? Norman Peelman <npeelman@cfl.rr.com> - 2013-06-08 15:32 -0400
  Re: deleted primary key can't be reused? gordonb.ps993@burditt.org (Gordon Burditt) - 2013-06-11 23:46 -0500
    Re: deleted primary key can't be reused? Denis McMahon <denismfmcmahon@gmail.com> - 2013-06-12 05:52 +0000
  Re: deleted primary key can't be reused? Doug Miller <doug_at_milmac_dot_com@example.com> - 2013-06-12 11:05 +0000
  Re: deleted primary key can't be reused? GravyCode <matty023@gmail.com> - 2013-06-21 10:25 -0700
    Re: deleted primary key can't be reused? gordonb.tuxls@burditt.org (Gordon Burditt) - 2013-06-23 04:05 -0500
      Re: deleted primary key can't be reused? The Natural Philosopher <tnp@invalid.invalid> - 2013-06-23 12:05 +0100
  Re: deleted primary key can't be reused? Marc van Lieshout <invalid@example.com> - 2013-06-21 19:52 +0200

csiph-web