mysql 去除换行字符和填充一张表的数据到另一张表对应的条目

UPDATE tf_category
SET NAME=REPLACE(NAME,"\r","")
WHERE 1=1


UPDATE tf_category
SET NAME=REPLACE(NAME,"\n","")
WHERE 1=1

mySQL去除换行字符和填充一张表的数据到另一张表对应的条目中

mysql去除换行

UPDATE dede_archives SET description=REPLACE(description,"\r","");

UPDATE dede_archives SET description=REPLACE(description,"\n","");

 

mysql表赋值

UPDATE dede_archives SET description = (SELECT body FROM dede_addonarticle WHERE aid = id) WHERE id IN (SELECT aid FROM dede_addonarticle WHERE aid=id);

SELECT * FROM dede_archives;