I hope I can explain this. I have a table which contains a field named ID. This is set as PRIMARY. Because users registered on my site and after that deleted their accounts (so a lot of rows got deleted, too) the table rows now are jumping, for example, from ID 33 to 3333.
What I want to do is to rewrite, somehow, the ID field, so the rows will start from 1 and end at the last row. Is there a way to do this?