I'm looking to re-order a table while keeping the table's id column constant.
ie, Links has entries in no particular order, whereas LinksPopular is a duplicated table but I want it ordered by category X, while leaving the id category unchanged.
That way the first most popular is at id 1, second at id 2, etc, instead of the index's being all over the place.
Does anyone know how to do this?
I've tried dropping the id column then re-adding it in order, but I couldn't get that to work with the auto_increment, and it doesn't seem very efficient.
Thanks in advance.