MySQL batch id alter

[Anon]

I have two consecutive databases which I would like to join (permanently) together.

The table structures are identical. I would like to add a fixed number to every value in one table so the id values do not overlap. Then I can mash the tables together to form one single archive.

How can I do this in SQL?

Any tips or suggestions would be much appreciated.

[Anon]

if the ID of the first is an autonumber, you could just select all the fields except the id of the records of the second and insert it in to the first. no need to do the step you mention.