> 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 ???
It might be me ... but why bother? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
