sql - 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

How about this

UPDATE table SET columnB = columnA;

This will update every row.