FUDforum: comp.lang.php » deleted primary key can't be reused?

Home » Imported messages » comp.lang.php » deleted primary key can't be reused?

Show: Today's Messages :: Polls :: Message Navigator

Re: deleted primary key can't be reused? [message #181845 is a reply to message #181827]

Wed, 12 June 2013 11:05

Doug Miller
Messages: 171
Registered: August 2011

Karma:

Senior Member

richard <noreply(at)example(dot)com> wrote in news:1riuk3ca2113p$.1butqaatdq7hw.dlg@
40tude.net:

> Entered 100 items into 2 columns each.
> Deleted 2.
> Upon entering new record using id of 98, no can do.

Did you perhaps delete records 99 and 100?

> The next new record number becomes 101.
> "Duplicate key error" is issued.

Apparently because you didn't delete record 98....

Report message to a moderator

[Message index]

		deleted primary key can't be reused? By: richard on Sat, 08 June 2013 14:24
		Re: deleted primary key can't be reused? By: richard on Sat, 08 June 2013 14:57
		Re: deleted primary key can't be reused? By: Luuk on Sat, 08 June 2013 15:46
		Re: deleted primary key can't be reused? By: The Natural Philosoph on Sat, 08 June 2013 17:47
		Re: deleted primary key can't be reused? By: Norman Peelman on Sat, 08 June 2013 19:32
		Re: deleted primary key can't be reused? By: gordonb.ps993 on Wed, 12 June 2013 04:46
		Re: deleted primary key can't be reused? By: Denis McMahon on Wed, 12 June 2013 05:52
		Re: deleted primary key can't be reused? By: Doug Miller on Wed, 12 June 2013 11:05
		Re: deleted primary key can't be reused? By: GravyCode on Fri, 21 June 2013 17:25
		Re: deleted primary key can't be reused? By: gordonb.tuxls on Sun, 23 June 2013 09:05
		Re: deleted primary key can't be reused? By: The Natural Philosoph on Sun, 23 June 2013 11:05
		Re: deleted primary key can't be reused? By: Marc van Lieshout on Fri, 21 June 2013 17:52

Previous Topic:	Read info from webcam video
Next Topic:	PHP form generator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 00:45:21 GMT 2024

Total time taken to generate the page: 0.06464 seconds