帝国CMS怎样删除清空文章数据库记录让后面发的文章ID重新从1开始呢? 1.登录后台 - 系统 - 备份与恢复数据 - 执行SQL语句 清空新闻字段:
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;
清空zb直段:
TRUNCATE [!db.pre!]ecms_zb;
TRUNCATE [!db.pre!]ecms_zb_check;
TRUNCATE [!db.pre!]ecms_zb_check_data;
TRUNCATE [!db.pre!]ecms_zb_data_1;
TRUNCATE [!db.pre!]ecms_zb_doc;
TRUNCATE [!db.pre!]ecms_zb_doc_data;
TRUNCATE [!db.pre!]ecms_zb_doc_index;
TRUNCATE [!db.pre!]ecms_zb_index;
参考字段在:系统 - 数据表与系统模型 - 管理数据表 