左右空格:update xx set name=trim(name); 左空格:update xx set name=ltrim(name); 右空格:update xx set name=rtrim(name);