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.
From: B Wiley Snyder [mailto:wwwileynet@stripped]
Sent: Mon 4/11/2005 7:38 PM
Subject: How to retain "Key" order when Deleting a Row
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
Express yourself instantly with MSN Messenger! Download today - it's FREE!
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=1