How do i create a copy values in one column to a different? I've:

Database name: list
number | test
123456 | somedata
123486 | somedata1
232344 | 34

I wish to have:

Database name: list
number | test
123456 | 123456
123486 | 123456
232344 | 232344

What mysql query must i have?

UPDATE `table` SET test=number
UPDATE `table_name` SET `test` = `number`

You may also inflict mathematical changes along the way or use MySQL functions to change the values.

do this:

update `list`
set `test` = `number`