<code>UPDATE `table` SET test=number</code>
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>