去掉字符前的空格,用ltrim(‘xxx’)
update users set `name`=ltrim(name)
去掉字符后的空格,用rtrim(‘xxx’)
update qx_users set `name`=rtrim(name)
去掉字符后的空格,用replace(‘xxx’,’ ‘,”)
update users set name=replace(name,’ ‘,”)
update users set `name`=ltrim(name)
update qx_users set `name`=rtrim(name)
update users set name=replace(name,’ ‘,”)
Comments | NOTHING