What is the easiest way to copy the all the values from a column in a table to another column in the same table?
With a single statement (if the columns have the same datatype)
UPDATE <tablename> SET <destination column name> = <source column name>