Inizio  >  Docs  >  Linux  >  Trucchi veloci  >  Mysql  
MysqlMysql

Index


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>