#copy one column data to another in sql Syntax UPDATE `table` SET new_column_name = old_column_name; Example UPDATE `toppers` SET tpicx = tpic;