transfering from one table to another
Posted: Tue Jun 29, 2004 1:36 pm
another basic question, but here it goes:
I have two tables. One table I just added to my database and one has been there since the beggining of my site. When people register for my site it creates a row in the first table with a column called user_id that is auto increment. The problem is, I need the table I just added to have the same user ids as the first table. How will I go about doing this besides having to manually update every userid? thanks.
I have two tables. One table I just added to my database and one has been there since the beggining of my site. When people register for my site it creates a row in the first table with a column called user_id that is auto increment. The problem is, I need the table I just added to have the same user ids as the first table. How will I go about doing this besides having to manually update every userid? thanks.