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;