Problem:
Copy the content of one column of a sql table into another column.
Solution:
both columns in same table:
update table1 set column2 = column1
both columns in different tables:
update table2 set column2 = (select column1 from table1)
Problem:
Copy the content of one column of a sql table into another column.
Solution:
both columns in same table:
update table1 set column2 = column1
both columns in different tables:
update table2 set column2 = (select column1 from table1)