<p>What is the easiest way to copy the all the values from a column in a table to another column in the same table?</p>

This script will update ALL values in the field1 with the values from the field2 in the corresponding row
```
```
UPDATE table SET field1 = field2
```
```