I have a database whose primary key is 'slno' and which is an auto increment field.I inserted some values to database say upto " slno - 5". Then I deleted the row with 'slno' 3 . Now I want the to shift all the rows upward ie 4th row should be third and its 'slno' should also be 3. I heard that this is not possible.Is there a way to do this other than to move all rows to another database except the slno.
