UPDATE table SET columnB = columnA;
UPDATE table_name SET destination_column_name=orig_column_name WHERE condition_if_necessary