Re: How to retain "Key" order when Deleting a Row

[Jason Martin]

On Tue, Apr 12, 2005 at 02:38:12AM +0000, B Wiley Snyder wrote:
> 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.
Such a thing isn't possible as it would require MySQL to update
every row 'past' the deleted row. Why do you need to do this?

-Jason Martin
-- 
Oxymoron: Steel wool.
This message is PGP/MIME signed.

Attachment: [application/pgp-signature]