1#copy one column data to another in sql
2
3Syntax
4UPDATE `table` SET new_column_name = old_column_name;
5
6Example
7UPDATE `toppers` SET tpicx = tpic;
1UPDATE table_name SET
2 destination_column_name=orig_column_name
3WHERE condition_if_necessary
4