Copy one column value in another column.

Table Name: list
number | test
123456 | 123456
123486 | 123486
232344 | 23234

UPDATE `list` SET test=number;