织梦删除所有文章并且id从1开始重新排序 code

admin 2017-06-21 4439

后台 - 系统 - SQL命令行工具

truncate table `dede_arctiny`;

truncate table `dede_archives`;

truncate table `dede_addonarticle`;

ALTER TABLE `dede_arctype` AUTO_INCREMENT =1;

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;

ALTER TABLE `dede_archives` AUTO_INCREMENT =1;

ALTER TABLE `dede_arctiny` AUTO_INCREMENT =1;

ALTER TABLE `dede_addonarticle` AUTO_INCREMENT =1;


最新回复 (0)
全部楼主
    • MSDN,我告诉你(中文站)
      2
        登录 注册 获取赞助码
返回