Page 1 of 1

copy the data from one column to another on the same table

PostPosted: Tue Jan 08, 2013 4:44 pm
by haretu
If you want to copy the data from one column to another on the same table:

UPDATE table_name SET
destination_column_name=orig_column_name
WHERE condition_if_necessary