I have a column, lets say "id", that is AUTO_INCREMENT. In it the most
recently
inserted row got an ID value of 100.
Now, lets say I kill off some rows from before,
and crunch down the
IDs
so that there are no skips in numbers, and now the most recently
inserted
row has an ID of 85.
When I instert a new row, the new ID will get a value of 101, as
opposed
to
86. Is there any way of resseting the auto_increment index so that I could
get
one greater than the greatest current id whenever I
insert?
thanks
