连表更新
作者:admin 发布时间:November 12, 2019 分类:Mysql
UPDATE ucenter_user_money a, (select user_id,openid,unionid from ucenter_user_details where openid!='') b SET a.openid = b.openid,a.unionid=b.unionid WHERE a.user_id = b.user_id
If there were you, the world would be just right
UPDATE ucenter_user_money a, (select user_id,openid,unionid from ucenter_user_details where openid!='') b SET a.openid = b.openid,a.unionid=b.unionid WHERE a.user_id = b.user_id