MySQL将查询记录复制到新表字段并更新当前记录

Question

我正在查询结果，我想将customer_id复制到新表字段old_customer_id，customer_id将替换最新记录.

+-------------+-----------------+
| customer_id | old_customer_id |
|-------------+-----------------+
|      5      |                 |
|      3      |                 |
|      1      |                 |
+-------------+-----------------+

在我的查询得到如上结果后，我想将 customer_id 复制到 old_customer_id ，它会

+-------------+-----------------+
| customer_id | old_customer_id |
|-------------+-----------------+
|      5      |        5        |
|      5      |        3        |
|      5      |        1        |
+-------------+-----------------+

Answer 1

UPDATE YourTable
SET old_customer_id = customer_id, customer_id = 5

DEMO