第一种：
update student set student.age =
(select `user`.age from user where id=student.id ) where student.`name`='lisi' ;
第二种：
update user left join user1129 on user.user_id=user1129.user_id set user.user_balance=user1129.user_balance where user.user_login_name = 'test';