dedecms做网站的时候,用到的模版还原之后会带有数据。一般文章较多的话想一次性清空。手动删自然会慢很多,而且删掉之后,ID就会接着从最后一篇文章开始计数。
所以需要在SQL命令里执行以下代码:
系统——SQL命令工具——复制下面语句然后执行即可。
truncate table `dede_arctiny`;
truncate table `dede_archives`;
truncate table `dede_addonarticle`;
ALTER TABLE `dede_arctype` AUTO_INCREMENT =1;
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 dede_archives;
ALTER TABLE `dede_archives` AUTO_INCREMENT =1;
ALTER TABLE `dede_arctiny` AUTO_INCREMENT =1;
ALTER TABLE `dede_addonarticle` AUTO_INCREMENT =1;
公众号:懒汉运营,关注获取免费资源。如若转载本文章,请注明出处:https://98seo.com/wangzhan/27.html