-- 此字符只影响终端的查询，如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
;