mysql中删除数据中的特殊字符
-- 此字符只影响终端的查询,如crt,xshell等,在navicat中不受影响
select
str
,replace(str,char(13),' ') as str_fix
from (
select concat('1',char(13),'2') as str
) t1
;
-- 此字符只影响终端的查询,如crt,xshell等,在navicat中不受影响
select
str
,replace(str,char(13),' ') as str_fix
from (
select concat('1',char(13),'2') as str
) t1
;