Thread: mysql清除数据库中字符串回车符方法
View Single Post
  #1   IP: 49.87.41.166
Old 2015-03-05, 09:35 AM
Agra Agra is offline
初级会员
  
Join Date: 2007-01-09
Posts: 2
Agra 现在声名狼藉
Default mysql清除数据库中字符串回车符方法
update `ucenter_members` set `username`=replace(`username`,'\r','');

清除用户名中的回车
Reply With Quote