1、给一个字段排序赋值
#执行后sort字段会依次赋值 1,2,3,4......,直到nv_class表总量
set @r:=0;
update nv_class_standard set sort=(@r:=@r+1)
2、去除字段中的空格
1)去除左侧空格
SELECT ltrim(name) from nv_class_standard where ltrim(name) = '123'
2)去除右侧空格
SELECT rtrim(name) from nv_class_standard where rtrim(name) = '123'
3)去除左右空格
SELECT trim(name) from nv_class_standard where trim(name) = '123'
4)去除全部空格(包括左右和中间)
SELECT replace(name,' ','') from nv_class_standard where replace(name,' ','') = '123'
更多内容请访问:IT源点
注意:本文归作者所有,未经作者允许,不得转载