copy data from one column to another in the same table

update `table` set `col1` = `col2` WHERE `col1` is null
Advertisements