How can I copy data from one column to another in the same table?

Question

Is it possible to copy data from column A to column B for all records in a table in SQL?

Answer 1

Use this code:

UPDATE table SET columnB = columnA;

This will be useful to update every row.