-
字符前的空格,用ltrim(string)
-
字符后的空格,用rtrim(string)
-
字符中的空格,用replace(string, ’ ', ’ ')
update student set NAME
=rtrim(NAME)
update student set NAME
=ltrim(NAME)
update student set NAME
=replace(NAME,’ ‘,’')
字符前的空格,用ltrim(string)
字符后的空格,用rtrim(string)
字符中的空格,用replace(string, ’ ', ’ ')
update student set NAME
=rtrim(NAME)
update student set NAME
=ltrim(NAME)
update student set NAME
=replace(NAME,’ ‘,’')