• 懒鸟飞:精品网站源码、帝国cms模板专业分享平台

织梦用sql命令行工具清空所有文章

本文主要讲解一下用织梦的后台的sql命令行工具清空所有文章。
 
1、织梦后台——系统——SQL命令行工具,选择多行命令
 
2、执行以下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;
 
QQ在线咨询
QQ客服
淘宝官网