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

Groups > comp.lang.php > #9854

Re: deleted primary key can't be reused?

Show all headers | 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