How to renumber primary index.
Posted
by Kamil Mroczek
on Stack Overflow
See other posts from Stack Overflow
or by Kamil Mroczek
Published on 2010-04-15T07:24:40Z
Indexed on
2010/04/15
7:33 UTC
Read the original article
Hit count: 175
I have got a simple MySQL table and primary index (id) is not numbered one by one (1, 31, 35, 100 etc.). I want them to be numbered like (1, 2, 3, 4). Please tell me how to do it. I would also like to point that I am aware of possible consequences of the operation, but I just want to tidy up the table.
© Stack Overflow or respective owner