copy data from one table column to another table column in sql
#to copy or update a table column from another table column
UPDATE table_name1
SET column1 = (
SELECT column2
FROM table_name2
WHERE table_name1.id = table_name2.id
);