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 [EMAIL PROTECTED] wrote on 04/11/2005 10:38:12 PM
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,9,10
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 when the
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
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.
Such