sql query to copy data from one column to another code example

Example 1: sql query to copy data from one column to another

UPDATE table SET columnB = columnA;

Example 2: sql query to copy data from one column to another

UPDATE table_name SET
    destination_column_name=orig_column_name
WHERE condition_if_necessary