select Concat(nf_nickname,nf_mobile) from nf_user; 转载于:https://www.cnblogs.com/xin-jun/p/8461799.html