title: Copy values from one column to another in the same table
body: <p>How can I make a copy values from one column to another?</p>
  <p>I have:</p>
  <pre><code>Database name: list
  
  -------------------
  number | test
  -------------------
  123456 | somedata
  123486 | somedata1
  232344 | 34
  </code></pre>
  <p>I want to have:</p>
  <pre><code>Database name: list
  
  ----------------
  number | test
  ----------------
  123456 | 123456
  123486 | 123486
  232344 | 232344
  </code></pre>
  <p>What MySQL query should I have?</p>