Some stupid questions

[TalkShowHost]

Hey guys I really need your help.

Okay well, I'm using phpMyAdmin (version 2.5.6 if it matters) and what I want to do is change all of the values in a table so that they are up one number.

What I mean is that say in a table called thing_allposts I want to change all the user_ids so that they are +1. (for example in each row the user_id 1 will be changed to 2 and the user_id 2 will be changed to 3 and so on) and I want to know if this is possible, and if so how.

If that's not possible, is there some command I can do to globably replace all of the values from one value to another?

Thanks for your time and try to be as specific as possible as I am a dumb newbie :p.

edit

Since in my newbish ways of trying to explain it I have lost all of you, I hope attaching this image will help tell you what I'm trying to do.

[planetsim]

You may find this SQL command useful

UPDATE

From there something like this should do the trick

UPDATE mytablename SET user_id = user_id + 1

[TalkShowHost]

Hey thank you so much no one else has been able to help fix my problem until now. The command you gave me worked for almost everything but on one commane I got this error:

Error

SQL-query :

UPDATE nuke_users SET user_id = user_id +1

MySQL said:

#1062 - Duplicate entry '2' for key 1

Hmmm, so how do I fix this one?

Thanks again, you helped me out so much with this. 🆒

[TalkShowHost]

Never mind, I fixed it. 🆒 .

Thanks again Planetsim you've helped me sooo much.

And thanks for putting up with my newbish-ness.