欢迎进入广州凡科互联网科技有限公司网站
全国服务热线
4000-399-000
织梦cmsdedecms大批量删掉并设定特定id自增
时间: 2021-02-24 07:43 浏览次数:
DELETE FROM dede_addonarticle WHERE aid 35645;DELETE FROM dede_arctiny WHERE id 35645;DELETE FROM dede_archives WHERE id 35645;ALTER TABLE dede_archives AUTO_INCREMENT =35645;ALTER TABLE dede_arctiny AUTO_INCREMENT =35645;ALTER TABLE dede_ad
DELETE FROM dede_addonarticle WHERE aid 35645;
DELETE FROM dede_arctiny WHERE id 35645;
DELETE FROM dede_archives WHERE id 35645;
ALTER TABLE dede_archives AUTO_INCREMENT =35645;
ALTER TABLE dede_arctiny AUTO_INCREMENT =35645;
ALTER TABLE dede_addonarticle AUTO_INCREMENT =35645;
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自增
ALTER TABLE dede_archives AUTO_INCREMENT =108;
ALTER TABLE dede_arctiny AUTO_INCREMENT =108;
ALTER TABLE dede_addonarticle AUTO_INCREMENT =108;


dedecms模版,dedecms公司模版,dedecms新闻资讯模版,高档HTML5响应式模版,dedecms手机上模版,织梦cms模版实例教程,网站模版,网页页面模版,完全免费网页页面模版

下一篇:没有了


Copyright © 广州凡科互联网科技有限公司 版权所有 粤ICP备10235580号
全国服务电话:4000-399-000   传真:021-45545458
公司地址:广州市海珠区工业大道北67号凤凰创意园