Question

dede怎么清空所有文章

Answer 1

进入网站后台默认是：http://你的域名/dede，点击系统-

SQL命令行工具，选择多行命令，如图

执行以下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 `dede_archives`;

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;