how to copy all data from one table to another which having different column code example

Example: copy all values of a column to another column in sql in same table

UPDATE table SET columnB = columnA;