thanks in advance for a clue
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:
> 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/ >
It sounds like you are confusing a data storage requirement (a unique, non-repeating identifier for every row) with a presentation requirement (a neatly numbered list of records). If I need a nicely ordered list of numbers, I use my programming language to provide it. If I need to uniquely identify a record, I use the ID.
When an ID has been issued, it generally stays "used" even if that record no longer exists.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine
_________________________________________________________________
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/[EMAIL PROTECTED]
