mysql去掉空格和换行 

UPDATE hd_check_plain SET UNAMELIST = REPLACE(REPLACE(UNAMELIST, CHAR(10), ''), CHAR(13), '');UPDATE hd_check_plain SET UNAMELIST = REPLACE(REPLACE(UNAMELIST, CHAR(10), ''), CHAR(13), '');

 

posted @ 2022-08-15 22:58  _Lawrence  阅读(100)  评论(0)  编辑  收藏  举报