这将删除前导和尾随空格

This will remove leading and trailing spaces

Update tablename set fieldName = ltrim(rtrim(fieldName));

某些版本的 SQL 支持

some versions of SQL Support

Update tablename set fieldName = trim(fieldName);

如果你只是想删除前导

update tablename set fieldName = LTRIM(fieldName);