广州凡科互联网科技有限公司

营业时间
MON-SAT 9:00-18:00

全国服务热线
18720358503

公司门店地址
广州市海珠区工业大道北67号凤凰创意园

织梦cmsSQL指令行专用工具常见实际操作编码

日期:2021-03-03 浏览:
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;



网站知识

联系方式丨CONTACT

  • 全国热线:18720358503
  • 传真热线:18720358503
  • Q Q咨询:2639601583
  • 企业邮箱:2639601583@qq.com

首页
电话
短信
联系