如上图,文章id本来是3万多,但突然涨到了6万多,并且id跳跃增长的速度越来越快。
现在我们需要做的是,先批量删除id大于等于35646的文章,之后指定id从35646开始自增,使用sql命令,代码如下:
DELETE FROM dede_addonarticle WHERE aid >=35646;
DELETE FROM dede_arctiny WHERE id >=35646;
DELETE FROM dede_archives WHERE id >=35646;
;
ALTER TABLE dede_archives AUTO_INCREMENT =35646;
ALTER TABLE dede_arctiny AUTO_INCREMENT =35646;
ALTER TABLE dede_addonarticle AUTO_INCREMENT =35646;
执行完上面6条代码后,就完成批量删除文章并设置id自增的工作。解释一下代码:
1、批量删除织梦文章代码,并指定删除的范围,如下id1000到id2000:
DELETE FROM dede_addonarticle WHERE aid >= 1000 and aid<=2000;
DELETE FROM dede_arctiny WHERE id >= 1000 and id<=2000;
DELETE FROM dede_archives WHERE id >= 1000 and id<=2000;
2、设置指定的id自增从1000开始
ALTER TABLE dede_archives AUTO_INCREMENT =1000;
ALTER TABLE dede_arctiny AUTO_INCREMENT =1000;
ALTER TABLE dede_addonarticle AUTO_INCREMENT =1000;
删除指定文章id
DELETE FROM dede_addonarticle WHERE aid=821;
DELETE FROM dede_arctiny WHERE id=821;
DELETE FROM dede_archives WHERE id=821;