mysql：如何将表中的2个字段相加并将结果放在第3个字段中？

lets say our table has the following structure

        col1 | col2 | col3

I want to sum col1 and col2 then update the col3 with the result

Thanks

UPDATE tablename SET col3 = col1 + col2