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

UPDATE table_name SET
    destination_column_name=orig_column_name
WHERE condition_if_necessary

How about this

UPDATE table SET columnB = columnA;

This will update every row.