258资源分享网

进入织梦后台——系统——系统设置——SQL命令行工具，选择多行命令，复制粘贴下面对应的SQL命令确定即可清除，新发布的栏目和文章的ID将从1开始。

清除织梦所有栏目SQL：

Delete from dede_arctype; ALTER TABLE dede_arctype AUTO_INCREMENT =1;  


清除所有文章：

Delete from dede_addonarticle; ALTER TABLE dede_addonarticle AUTO_INCREMENT =1; Delete from dede_arctiny; ALTER TABLE dede_arctiny AUTO_INCREMENT =1; Delete from dede_archives; ALTER TABLE dede_archives AUTO_INCREMENT =1;  


清除所有文章关键词：

Delete from dede_keywords; ALTER TABLE dede_keywords AUTO_INCREMENT =1;  


清除所有搜索关键词：

Delete from dede_search_keywords; ALTER TABLE dede_search_keywords AUTO_INCREMENT =1;  


清除所有标签：

Delete from dede_tagindex; ALTER TABLE dede_tagindex AUTO_INCREMENT =1; Delete from dede_taglist; ALTER TABLE dede_taglist AUTO_INCREMENT =1;  


清除上传的图片和附件：
进入网站uploads目录中找到日期时间格式的文件夹删除即可。




以上代码整理到下边了，复制后执行即可： Delete from dede_arctype; ALTER TABLE dede_arctype AUTO_INCREMENT =1; Delete from dede_addonarticle; ALTER TABLE dede_addonarticle AUTO_INCREMENT =1; Delete from dede_arctiny; ALTER TABLE dede_arctiny AUTO_INCREMENT =1; Delete from dede_archives; ALTER TABLE dede_archives AUTO_INCREMENT =1; Delete from dede_keywords; ALTER TABLE dede_keywords AUTO_INCREMENT =1; Delete from dede_search_keywords; ALTER TABLE dede_search_keywords AUTO_INCREMENT =1; Delete from dede_tagindex; ALTER TABLE dede_tagindex AUTO_INCREMENT =1; Delete from dede_taglist; ALTER TABLE dede_taglist AUTO_INCREMENT =1;