Pls help me out [message #41218] |
Tue, 10 December 2002 15:51 |
Vinod
Messages: 76 Registered: April 1999
|
Member |
|
|
I have created a new column in one table. I want all the values here to exactly same as in another column in the same table. what is the best method to copy the values row by row from one column to another column in the same table.
I want this very urgently pls
Thanks
Vinod
|
|
|
Re: Pls help me out [message #41220 is a reply to message #41218] |
Tue, 10 December 2002 22:17 |
Deepa
Messages: 269 Registered: November 2000
|
Senior Member |
|
|
hi,
you have to do an update statement for the column which you want to copy.
if u have the values in the column2 and want to copy the value to column1 of the same table ,following query solves your problem.
update table test
set column1=column2;
regards,
deepa
|
|
|