range

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;

批量更新
UPDATE yisdk_device a, ( SELECT uuid, channel, pf_game_id, utma, MD5( CONCAT( "new_", CONCAT_WS( "_", channel, pf_game_id, utma ))) AS new_uuid FROM yisdk_device WHERE addtime >= '1588262400' AND uuid != MD5( CONCAT( "new_", CONCAT_WS( "_", channel, pf_game_id, utma )))) b SET a.uuid = b.new_uuid WHERE a.channel = b.channel and a.pf_game_id = b.pf_game_id and a.utma = b.utma