A
Anonymous
Guest
RPG_2004's advice is correct. Basically you have to add one to the id of every record after the one in question. And you have to do it backwards (hence the DESC).
Note that you should not write a script that does this frequently, because it's a very slow operation.
Note that you should not write a script that does this frequently, because it's a very slow operation.