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

user_rank!=1;