update peppa.user_profile_extension t1,ucenter.student_profile t3
set t1.weight=t3.weight
where t1.user_Id=t3.user_id and t1.user_id in
( select user_Id from ucenter.student_profile where weight is not null )
mysql用一张表的字段更新另一张表
最新推荐文章于 2024-07-28 03:26:33 发布