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

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

I want to have:

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

UPDATE`table`SET test=number

To top