Thanks, I don't know what I was thinking ?!?
From: [EMAIL PROTECTED]
To: "B Wiley Snyder" <[EMAIL PROTECTED]>
CC: mysql@lists.mysql.com
Subject: Re: How to retain "Key" order when Deleting a Row
Date: Tue, 12 Apr 2005 14:48:54 -0400
"B Wiley Snyder" <[EM
"B Wiley Snyder" <[EMAIL PROTECTED]> wrote on 04/11/2005 10:38:12 PM:
> Hello experts,
>
> I just need someone to please point me in the right direction on
retaining
> my "key" or id order in my table when I delete a row. So for example I
have
> 10 rows Id 1-10 that are created automatically
> I just need someone to please point me in the right direction on retaining
> my "key" or id order in my table when I delete a row. So for example I
have
> 10 rows Id 1-10 that are created automatically when the record is
inserted.
>
> So if I delete record with id 5 my id's are not 1,2,3,4,6,7,8
On Tue, Apr 12, 2005 at 02:38:12AM +, B Wiley Snyder wrote:
> I just need someone to please point me in the right direction on retaining
> my "key" or id order in my table when I delete a row. So for example I have
> 10 rows Id 1-10 that are created automatically when the record is inserted.
Hi,
If I understand your question correctly, your remaining keys after the delete
will be '1,2,3,4,6...'. The keys will not reorder, so five should be gone, and
the next record inserted will be 11.
//jjs
-Original Message-
From: B Wiley Snyder [mailto:[EMAIL PROTECTED]
Sent: Mon 4/11/2
