update表关联

分类: IT文章 • 2025-01-31 19:20:31

第一种：

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';