dedecms怎么清空所有文章
2018-06-09 本文已影响0人
开拓族
进入网站后台默认是: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;