帝国cms使用sql语句设置信息id从指定id开始递增

正文概述管理员 2025-09-04 4

先备份先备份先备份先备份先备份！！

ALTER TABLE phome_ecms_news AUTO_INCREMENT = 10000;
ALTER TABLE phome_ecms_news_check AUTO_INCREMENT = 10000;
ALTER TABLE phome_ecms_news_check_data AUTO_INCREMENT = 10000;
ALTER TABLE phome_ecms_news_data_1 AUTO_INCREMENT = 10000;
ALTER TABLE phome_ecms_news_doc AUTO_INCREMENT = 10000;
ALTER TABLE phome_ecms_news_doc_data AUTO_INCREMENT = 10000;
ALTER TABLE phome_ecms_news_doc_index AUTO_INCREMENT = 10000;
ALTER TABLE phome_ecms_news_index AUTO_INCREMENT = 10000;

以上语句意思是增加信息从ID10000开始