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 4/11/2005 7:38 PM To: mysql@lists.mysql.com 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/[EMAIL PROTECTED]
