List:General Discussion« Previous MessageNext Message »
From:John Schmidt Date:April 12 2005 2:51am
Subject:RE: How to retain "Key" order when Deleting a Row
View as plain text  
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:wwwileynet@stripped]
Sent: Mon 4/11/2005 7:38 PM
To: mysql@stripped
Subject: How to retain "Key" order when Deleting a Row
 
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 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 but 
1,2,3,4,5,6,7,8,9 ???


thanks

_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE! 
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1



Thread
How to retain "Key" order when Deleting a RowB Wiley Snyder12 Apr
  • Re: How to retain "Key" order when Deleting a RowJason Martin12 Apr
  • Re: How to retain "Key" order when Deleting a RowMartijn Tonies12 Apr
  • Re: How to retain "Key" order when Deleting a RowSGreen12 Apr
    • Re: How to retain "Key" order when Deleting a RowB Wiley Snyder15 Apr
    • MySQL bottleneckB Wiley Snyder16 Apr
      • Re: MySQL bottleneckvalentin_nils17 Apr
        • Re: MySQL bottleneckB Wiley Snyder17 Apr
RE: How to retain "Key" order when Deleting a RowJohn Schmidt12 Apr
Re: MySQL bottleneckB Wiley Snyder17 Apr
Re: MySQL bottleneckB Wiley Snyder17 Apr
  • Re: MySQL bottleneckvalentin_nils17 Apr
    • Starting a thread (Was Re: MySQL bottleneck)Michael Stassen17 Apr
  • Re: MySQL bottleneckMartijn Tonies17 Apr