update kcxuesheng set chinaid=ltrim(rtrim(chinaid)) 先右边,再左边,等于前后都去
update kcxuesheng set chinaid=rtrim(chinaid) 只去右边
update kcxuesheng set chinaid=ltrim(chinaid) 只去左边
另外,你用replace试试replace(str,' ','')
update kcxuesheng set chinaid=replace(chinaid,'
','') // 这种中间空格也能去
update userinfo set chinaid=replace(chinaid,'
','')
但是 具体的空格是什么,最好是复制数据表字段里的,把多余的复制出来,用SQL语句替换下
完整代码 (代码框可以往下拉高显示):