dede一键删除所有文章的SQL命令

在系统-sql里执行下面指令就可以了

dede一键删除所有文章的SQL命令：

DELETE FROM dede_addonarticle WHERE aid >= 1 and aid<=200000;

DELETE FROM dede_arctiny WHERE id >= 1 and id<=200000;

DELETE FROM dede_archives WHERE id >= 1 and id<=200000;

文章id从0开始

ALTER TABLE `dede_archives` AUTO_INCREMENT =1; 

ALTER TABLE `dede_arctiny` AUTO_INCREMENT =1; 

ALTER TABLE `dede_addonarticle` AUTO_INCREMENT =1; 

本文标签：

转载请注明出处： http://www.iuseo.com/post/77.html