CODE EXAMPLE FOR SQL

duplicate column values

-- copy values from old column to new column
UPDATE tablename SET new_column = old_column