某些站长朋友就喜欢ID从1开始!而帝国CMS的ID是自增值!并不是后台一删除就可以的!细心的站长就会发现!这样的神操作id都不是从1开始的了!那么有强烈洁癖症的站长该怎么做呢!能让数据清空后ID从1开始呢!那么就是我们今天写的主题,帝国CMS数据表id清零和栏目数量清零TAGS表等清零的方法。方法如下:
-
- TRUNCATE `[!db.pre!]enewsclass`;
- TRUNCATE `[!db.pre!]enewsclassadd`;
-
- update `[!db.pre!]enewsclass` set infos = 0, allinfos = 0 where classid=2 limit 1;
-
- TRUNCATE `[!db.pre!]enewslog`;
-
- TRUNCATE `[!db.pre!]enewsdolog`;
-
- TRUNCATE `[!db.pre!]enewsloginfail`;
-
- TRUNCATE `[!db.pre!]ecms_news`;
- TRUNCATE `[!db.pre!]ecms_news_check`;
- TRUNCATE `[!db.pre!]ecms_news_check_data`;
- TRUNCATE `[!db.pre!]ecms_news_data_1`;
- TRUNCATE `[!db.pre!]ecms_news_doc`;
- TRUNCATE `[!db.pre!]ecms_news_doc_data`;
- TRUNCATE `[!db.pre!]ecms_news_doc_index`;
- TRUNCATE `[!db.pre!]ecms_news_index`;
-
- TRUNCATE `[!db.pre!]enewstags`;
- TRUNCATE `[!db.pre!]enewstagsclass`;
- TRUNCATE `[!db.pre!]enewstagsdata`;
-
- TRUNCATE `[!db.pre!]enewsmember`;
- TRUNCATE `[!db.pre!]enewsmemberadd`;
-
- TRUNCATE `[!db.pre!]enewspayrecord`;
-
- TRUNCATE `[!db.pre!]enewsdownrecord`;
-
- TRUNCATE `[!db.pre!]enewsbuybak`;
-
- TRUNCATE `[!db.pre!]enewsfile_1`;
注意执行命令的时候要提前备份数据库,小编不承担数据丢失带来的责任哦!