Here is the senerio. I have 1 table (members) and an primary ID that is autoincrmenting. I rely on this ID to be in order i.e 1,2,3,4,5..... If I go and say do this
Delete from members where (ID = 3);
My order now reads... 1,2,4,5....
Is there anyway to execute a specific MySQL command to make those numbers sync up after deleting the spcific row? Thanks!!!!