格式: UPDATE teacher SET name = REPLACE(name,' ', '') 示例: update lztest set dept_code= REPLACE(dept_code,' ','') from lztest 转载于:https://blog.51cto.com/51you/1100033