POST TIME:2020-03-30 16:52
幫客戶整理文檔時,有好多文檔不需要,而按織夢自定的的刪除文章功能要很久不方便,便想到了用織夢dedecms使用SQL語句批量刪除指定ID范圍文章
DELETE FROM dede_addonarticle WHERE aid >= 1 and aid<=2000;
DELETE FROM dede_arctiny WHERE id >= 1 and id<=2000;
DELETE FROM dede_archives WHERE id >= 1 and id<=2000;
id>= 1 這里的1是從文章ID為1開始,到2000; 大家可以自己設定;