mysql 复制记录的某个字段到其他记录

1. 将name=234记录的period字段值赋给name=123记录的period字段

update table1 set period = (select b.period from (select period from table1 where  name='234') b)  where name='123';