I'm new to sql and mysql, so forgive me if I'm not asking this in the best
way.


I have a table with a column that should contain a list of integers from 1
to the number of rows that identify the order of the rows as they should
appear elsewhere in an application. I need to do some error checking to see
if all numbers are present or if there are any missing or any duplicates.
That's easy enough through the application, but don't know how to write the
sql to correct the problem if it is found. Could someone tell me how to
change the original column below into the desired one?

Thanks

Jeff

original
1
2
3
3
5
8


desired
1
2
3
4
5
6



--
Posted via a free Usenet account from http://www.teranews.com