From: Martijn Tonies
Date: April 12 2005 8:32am
Subject: Re: How to retain "Key" order when Deleting a Row
List-Archive: http://lists.mysql.com/mysql/182486
Message-Id: <011001c53f3a$2eddd470$3802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit


> 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