I have a table and I want to run a SQL update statement that will update one column/field from another in the same DB. So, for examples, I was to update tablename.column2 to the value of tablename.column1. What is the best way to do this? It should be noted that there there is no condition required i.e. no WHERE statement needed - all the rows should be affected.
BTW the table is already modeled.