CHAR(10): 换行符
CHAR(13): 回车符
UPDATE t_attach_info SET url = REPLACE(REPLACE(url, CHAR(10), ''), CHAR(13), '');
CHAR(10): 换行符
CHAR(13): 回车符
UPDATE t_attach_info SET url = REPLACE(REPLACE(url, CHAR(10), ''), CHAR(13), '');
本文标题:MySQL处理换行符
本文链接:https://www.haomeiwen.com/subject/aotzwhtx.html
网友评论