需求:将id为1的address字段值复制到id为2的address update user_info u1,user_info u2 set u2.address=u1.address where u1.id=1 and u2.id=2;