mysql 去除前后空白字符 update table set field = replace(replace(replace(field,char(9),''),char(10),''),char(13),'');