update nm_user set nickname=TRIM(Replace(Replace(Replace(nickname,'\t',''),'\n',''),'\r',''))
转载于:https://www.cnblogs.com/juepei/p/4820173.html
update nm_user set nickname=TRIM(Replace(Replace(Replace(nickname,'\t',''),'\n',''),'\r',''))
转载于:https://www.cnblogs.com/juepei/p/4820173.html