DEDE后台常用SQL语句

最新推荐文章于 2021-12-23 11:31:04 发布

选调生

最新推荐文章于 2021-12-23 11:31:04 发布

阅读量307

点赞数

分类专栏： CMS插件

本文链接：https://blog.csdn.net/bobbsh/article/details/104594052

版权

CMS插件专栏收录该内容

12 篇文章 0 订阅

订阅专栏

全站所有文章为动态执行SQL: update dede_archives set ismake=-1
栏目批量设置为动态执行SQL: update dede_arctype set isdefault=-1
删除掉搜索关键词 DELETE FROM dede_search_keywords WHERE aid >= 1 and aid<=200000
删除TAG标签 delete FROM dede_tagindex where typeid not in (SELECT id FROM dede_arctype);
delete FROM dede_taglist where typeid not in (SELECT id FROM dede_arctype)
删除全站关键词 Delete from dede_search_cache;
Delete from dede_search_keywords;
Delete from dede_keywords