mysql替换空格制表符换行

发表于

update ztbdb_pro set pro=REPLACE(pro,CHAR(10),'');
update ztbdb_pro set pro=REPLACE(pro,CHAR(13),'');
update ztbdb_pro set pro=REPLACE(pro,CHAR(9),'');
update ztbdb_pro set pro=REPLACE(pro,' ','');
update ztbdb_pro set pro=REPLACE(pro,' ','');
char(9)=>水平制表符
char(10)=>换行建
char(13)=>回车键
SELECT * FROM rf_novel WHERE id in( 4,120293 )
update rf_novel set content=REPLACE(content,' ',CHAR(10)) WHERE id = 120293;
update rf_novel set content=REPLACE(content,CHAR(10),' ') WHERE id = 120292;

评论

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注