删除mysql数据中的空格和换行符

update zljianjie set phone=replace(replace(phone,char(10),''),char(13),'')