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
