update zljianjie set phone=replace(replace(phone,char(10),''),char(13),'')
转载于:https://www.cnblogs.com/shamojituan/p/7881116.html
update zljianjie set phone=replace(replace(phone,char(10),''),char(13),'')
转载于:https://www.cnblogs.com/shamojituan/p/7881116.html