Index

Copy values from one column to another in the same table

How can I make a copy values from one column to another? I have:

<code>Database name: list 
number | test 
123456 | somedata 
123486 | somedata1 
232344 | 34</code>

I want to have:

<code>Database name: list 
number | test 
123456 | 123456 
123486 | 123486 
232344 | 232344</code>

<code>UPDATE `table` SET test=number</code>