Hello,

I have a table that has a column with numbers in a sequence, but for some numbers they can be in groups with several of the same number. Then when the user deletes out a group, there can be a gap in the numbers. What I want to do is resequence that column so it starts at 1, then proceeds up to the last column. So for example, the table column named Item could look like this:

1
1
2
3
5
5
7
8
8

and I want it to convert to this:

1
1
2
3
4
4
5
6
6

Is there a way to do this in MySQL?

Thanks,

Pete