dede怎么清空所有文章
答案:1 悬赏:60
解决时间 2021-01-18 00:29
- 提问者网友：川水往事
- 2021-01-17 10:38
dede怎么清空所有文章
最佳答案
- 二级知识专家网友：封刀令
- 2021-01-17 11:20
进入网站后台默认是：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;
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;
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
点此我要举报以上问答信息！
大家都在看
推荐信息