dede如何清空文档从1开始

清空文档：进入SQL工具输入下列命令

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;

或是

TRUNCATE TABLE `xxxx_archives`;      //清空“普通文章模型”主表中的全部数据xxxx默认是dede

TRUNCATE TABLE `xxxx_addonarticle`;     /清空“普通文章模型”附表中的全部数据

TRUNCATE TABLE `xxxx_arctiny`;     //清空文档微表中的全部数据，使用栏目后的文档数量统计归零

计数从1开始：

ALTER TABLE `xxxx_archives` AUTO_INCREMENT =1;     //使“普通文章模型”主表中新增数据(即文章)的id号归1

ALTER TABLE `xxxx_addonarticle` AUTO_INCREMENT =1;     //使“普通文章模型”附表中新增数据(即文章)的id号归1

ALTER TABLE `xxxx_arctiny` AUTO_INCREMENT =1;     //使文档微表中新增数据(即文章)的id号归1