Adding to values in a mySQL table

[DKasler]

Ok... Im trying to merge my forums withs another guys forums and we can not have duplicate post Ids... so. I need a line of code a that will add to the post id value.

example:

PID
1
2
3
4
5

etc and add say... 2000 to the values.

PID
2001
2002
2003
etc

Thanks in advance.

PS. No the field is not auto_incremented so ALTER TABLE (your table) AUTO_INCREMENT = 2000 wil not work

 

[DKasler]

Thanks. I found what I needed.

update yourtable set PID=PID+2000