Re: Auto Increment issue

[Peter Brawley]

The usual cause is an accidental user edit.

A common fix, given the last value before the jump interval of X and a first jumped value Y ...

set @x=X, @y=Y;

update tbl set id=id - (@y-@x-1)
where id >= @y;