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;
发表回复