河南网站建设-郑州网站设计-郑州网站建设-手机建站-郑州建站-上海建站

织梦sql命令批量更改列表页、文章页模板:

update hczhz_arctype set templist = replace(templist,"{style}/list_article_xbk.htm",'{style}/list_article.htm') where id in (274,275,276);

织梦sql命令批量更改列表页、文章页模板:

update hczhz_arctype set temparticle = replace(temparticle,"{style}/article_article_xb.htm",'{style}/article_article.htm')

织梦sql命令批量替换文章描述:

update dede_archives set description=replace(description,'改之前','改之后');

织梦sql命令批量替换文章标题:

update dede_archives set title=replace(title,'改之前','改之后');

织梦sql命令批量替换文章内容:

update dede_addonarticle set body=replace(body,'改之前','改之后');

织梦sql命令批量删除文章内容:

DELETE FROM dede_addonarticle WHERE aid >= 1000 and id<=2000;

DELETE FROM dede_arctiny WHERE id >= 1000 and id<=2000;

DELETE FROM dede_archives WHERE id >= 1000 and id<=2000;

清空网站所有文章的命令：

truncate table `dede_arctiny`;

truncate table `dede_archives`;

truncate table `dede_addonarticle`;

新发布文章ID从1开始：

ALTER TABLE `dede_arctype` AUTO_INCREMENT =1;

然后再发布文章id都是从1开始了。

转载请标注：东东工作室——织梦sql命令批量更改列表页、文章页模板及文章的内容等