sql指令注释：

update (表名) set (要改动的 字段名名+改动后的 取值) where (挑选标准)

update：是一数量据库sql英语的语法术语，主要用途是升级表格中原来数据信息

where：挑选标准，指你需要改动什么数据信息內容，用标准句子挑选获取特定內容

织梦cms常见的变更SQL指令: 织梦cmssql指令大批量变更目录页模版: update dede_arctype set templist = replace(templist, {style}/list_qz.htm , {style}/oz_ongpage.htm ) where id in (29,20,31,35,36,37,38,40,41,42,43,44,45,46,47)

update dede_archives set set temparticle = replace(temparticle, {style}/article_article_xb.htm , {style}/article_article.htm

update `dede_archives` set click=598

update `dede_archives` set click=598 WHERE id=131

注：表明升级ID131的文本文档点一下为598

update `dede_archives` set click=598 WHERE typeid=131

注：表明升级频道ID为131的文本文档点一下为598

update dede_archives set writer=replace(writer, admin , 小梦blog

update dede_archives set source=replace(source, 不明 , 小梦blog

update dede_archives set title=replace(title, 改以前 , 改以后

比如：我觉得把题目中 小梦blog 改 seoblog ：update dede_archives set title=replace(title, 小梦blog , seoblog

update dede_archives set description=replace(description, 原先的重要词 , 更换后的重要词

update dede_addonarticle set body=replace(body, 原先的重要词 , 更换后的重要词

织梦cmssql指令改动题目长短限定： 改动dedecms系统软件》系统软件主要参数》别的选择项》文本文档题目***大长短为200，改此主要参数后必须手工制作改动数据信息表：

alter table dede_archives modify column title varchar(200)

update dede_addonarticle set body=replace(body, href= /

比如：

update dede_archives set arcrank=0

注：arcrank=0 仅动态性

织梦cmssql指令变更缩列图文件目录： update dede_archives set litpic=replace(litpic, 原先的标识符 , 更换后的标识符 )

比如：update dede_archives set litpic=replace(litpic, uplimg, tupian )

将全部文本文档设定为 仅动态性 ：update dede_archives set ismake=-1

将全部文本文档设定为 仅静态数据 ：update dede_archives set ismake=1

将全部频道设定为 应用动态性页 ： update dede_arctype set isdefault=-1

将全部频道设定为 应用静态数据页 ： update dede_arctype set isdefault=1

织梦cms常见的删掉SQL指令: 怎样除掉url中/a/文件目录呢？ 1、最先在系统软件设定》系统软件主要参数，文本文档html默认设置储存相对路径，把a除掉。

2、在dedecms后台管理中sql指令中实行下边sql指令，随后再次转化成网页页面。

编码以下:

update dede_arctype set typedir=replace(typedir, a/ , )

delete from dede_addonarticle where aid

delete from dede_arctiny where id

delete from dede_archives where id

delete from dede_addonarticle where aid = 100 and aid =5000;

delete from dede_arctiny where id = 100 and id =5000;

delete from dede_archives where id = 100 and id =5000;

织梦cmssql指令大批量删掉某一频道下面章： delete from dede_addonimages where typeid = 7;

delete from dede_arctiny where typeid = 7;

delete from dede_archives where typeid = 7;

织梦cmssql指令大批量删掉特定频道： delete from dede_arctype where id in (93,94,95,96,97)

注：这一段sql指令便是把频道id为93、94、95、96、97的频道删掉没了

update dede_archives set typeid= 70 where typeid in (93,94,95,96,97)

织梦cmssql指令大批量合拼频道到特定频道为子频道： Update `dede_arctype` set reid= 总体目标父频道ID where id in(2,3,4,5)

delete from dede_addonarticle;

delete from dede_addonimages;

delete from dede_archives;

delete from dede_arctiny;

delete from dede_co_htmls;

delete from dede_co_urls;

delete from dede_co_mediaurls;

delete from dede_tagindex ;

delete from dede_taglist;

delete from dede_keywords;

alter table `dede_archives` auto_increment =1;

alter table `dede_arctiny` auto_increment =1;

alter table `dede_addonarticle` auto_increment =1;

织梦cms兴新布频道id从1刚开始： alter table `dede_arctype` auto_increment =1;

• 上一篇：上海市百货杂志期刊专家社
• 下一篇：没有了