title: MySQL copy query records to new table field and update current records
body: <p>I'm query the result and I would like to copy <code>customer_id</code> to new table field <code>old_customer_id</code> and the <code>customer_id</code> will replace the latest records.</p>
  
  <pre><code>+-------------+-----------------+
  | customer_id | old_customer_id |
  |-------------+-----------------+
  |      5      |                 |
  |      3      |                 |
  |      1      |                 |
  +-------------+-----------------+
  </code></pre>
  
  <p>After my query get the result like above, I would like to copy the <code>customer_id</code> to <code>old_customer_id</code> which it will</p>
  
  <pre><code>+-------------+-----------------+
  | customer_id | old_customer_id |
  |-------------+-----------------+
  |      5      |        5        |
  |      5      |        3        |
  |      5      |        1        |
  +-------------+-----------------+
  </code></pre>