update `znxfy_user` set realname = nickname,shopname=concat(nickname,"的店铺"),shoplogo=headimgurl where is_salesmen=2 and user_rank!=1;