DEDE后台常用SQL语句

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

原创最新推荐文章于 2021-12-23 11:31:04 发布 · 343 阅读

0 ·

CC 4.0 BY-SA版权

CMS插件专栏收录该内容

12 篇文章

订阅专栏

本文详细介绍使用SQL语句对DEDECMS系统进行数据库优化的方法，包括动态执行、栏目设置、关键词与标签清理等关键步骤，帮助提升网站性能。

全站所有文章为动态执行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