Need to Recount Post ID column in table starting at 2000 instead of 1

I'm working with another guy trying to merge two websites and our forums. I need to modify the posts id for one of the forums to prevent duplicate postid's. One forum has just over 2000 posts. The other has 450 posts. Is it even possible to recount the PID column so that it counts from 2001-2450 instead of 1-450?

Thanks in advance and let me know if you need more information.

try a select insert (assuming your trying to merge the tables)

something like

INSERT INTO TABLE (fld_1, fld_2, etc)
SELECT fld_1, fld_2, etc
FROM TABLE2 WHERE (whatever you need to do)

I would do this from the table with 450 in it. The ID should then become an increment of the table with 2000 entries so the first new entry will be 2001 methinks (cant be sure without testing it, but I think it should do the trick)

Always remember to let the database do the work, no good attempting complex formula when its probably built into your database.

if your not merging them try

ALTER TABLE (your table) AUTO_INCREMENT = 2000

will set the auto_increment to 2000

Ibbo

Unfortunately the table is not auto incremented.

I need a line of code a that will add to the post id.

PID
1
2
3
4
5

etc and add 2000 to them say

PID
2001
2002
2003
etc

Thanks. I found what I needed.

update yourtable set PID=PID+2000