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

[David Fells]

You'd have to do a second query manually, and there is really no point in doing this. It's a bad idea to rely on a machine generated sequence for operations in general.. but if you must...


DELETE FROM table WHERE id = 5;
UPDATE table SET id = id-1 WHERE id > 5;