UPDATE table_name
SET role_code = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(role_code,CHAR(9),''),CHAR(10),''),CHAR(13),''),' ',''),'\r\n','')
mysql 去掉数据特殊字符
最新推荐文章于 2024-07-03 12:09:05 发布
UPDATE table_name
SET role_code = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(role_code,CHAR(9),''),CHAR(10),''),CHAR(13),''),' ',''),'\r\n','')