Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #9781

Re: deleted primary key can't be reused?

Show all headers | View raw

On 08/06/13 15: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.
there is a way to do this because I have. You can renumber all the IDS 
but it aint trivial.

But the point about a proper unique primary key is that it is forever 
associated with a particular record. Beware of what you wish for.

-- 
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to lead are elected by the least capable of producing, and where the members of society least likely to sustain themselves or succeed, are rewarded with goods and services paid for by the confiscated wealth of a diminishing number of producers.

Back to comp.lang.php | Previous | Next — Previous in thread | Next 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