Question: how to transfer data from one column to another in sql?
Answer: UPDATE table1 SET column1 = ( SELECT column2 FROM table2 WHERE table2.id = table1.id ); Whereby: table1 = table that has the column that needs to be updated. table2 = table that has the column with the data.