At 6:59 AM -0400 4/28/1999, Dave Crawford wrote:
>I apologize for my mistype last night, it was late. What I meant was:
>delete from table where (ID < 40);
>Where I deleted all records with an ID of less than 40. I tested it
>again this morning and yes, it definitely moves the record in the #40
>'slot' down to #1 along with 'sliding' down the remaining records.
I tried a similar thing and I don't see this problem. And inserting
new records correctly causes new values greater than the existing
values to be used. What version of MySQL were you using again?
(I'm using 3.22.21.)
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/