织梦dedecms怎么清空所有文章

分类:SQL语句教程 发布时间:2019-02-20 08:31:51

摘要:dedecms怎么清空所有文章,sql语句,清空织梦所有文章,织梦dede删除所有文章的方法,执行以下SQL语句就可以清空网站所有文章,如何快速删除织梦所有文章

进入网站后台,默认是:http://你的域名/dede/,点击

系统>SQL命令行工具,选择多行命令,如图

织梦dedecms怎么清空所有文章 第1张

执行以下SQL语句就可以清空网站所有文章

  1. delete from dede_addonarticle;
  2. delete from dede_addonimages;
  3. delete from dede_archives;
  4. delete from dede_arctiny;
  5. delete from dede_co_htmls;
  6. delete from dede_co_urls;
  7. delete from dede_co_mediaurls;
  8. delete from dede_tagindex ;
  9. delete from dede_taglist;
  10. delete from dede_keywords;
  11. TRUNCATE TABLE `dede_archives`;
  12. TRUNCATE TABLE `dede_archives`;
  13. ALTER TABLE `dede_archives` AUTO_INCREMENT =1;
  14. ALTER TABLE `dede_arctiny` AUTO_INCREMENT =1;
  15. ALTER TABLE `dede_addonarticle` AUTO_INCREMENT =1;