I have a column "ID" in a table, and I need to move that to another table in the same database. How do I do this?
desiguru
0
Junior Poster in Training
Recommended Answers
Jump to PostIf you want to 'move' a column from one table to another table, both the tables should have a common column to link these 2 tables. First, as Vermadba has mentioned, you have to create a column called "id" in table_2 first. Then, update the second table's "id" column using …
All 3 Replies
varmadba
12
Junior Poster in Training
desiguru
0
Junior Poster in Training
nav33n
472
Purple hazed!
Team Colleague
Featured Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.