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

Filed under:
|

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

Related posts about sql

Related posts about mysql