0

I have a table with an auto increment column uid. Over the time, the table has filled and some entries were deleted. I want to reassign all auto increment values of my table and I found a solution here. But I want to know, if there is a more proper way to do this and if not, does this method keep the sorting of the rows?

Community
  • 1
  • 1
Cubi73
  • 1,891
  • 3
  • 31
  • 52
  • What made you conclude that the idea presented in the linked post are not efficient? and yes, it will keep the sorting order. Just try it and see yourself. – Rahul May 29 '14 at 16:45
  • I thought, that deleting the column and adding a new column is just a workaround for this problem. And thank you :) – Cubi73 May 29 '14 at 17:38

0 Answers0