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.
MySQL batch id alter
- Thread starter wxdqz
- Start date