美文网首页
dedecms怎么清空所有文章

dedecms怎么清空所有文章

作者: 开拓族 | 来源:发表于2018-06-09 00: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;

相关文章

网友评论

      本文标题:dedecms怎么清空所有文章

      本文链接:https://www.haomeiwen.com/subject/ekvzsftx.html