POST TIME:2020-03-30 16:52
幫客戶整理文檔時(shí)，有好多文檔不需要，而按織夢(mèng)自定的的刪除文章功能要很久不方便，便想到了用織夢(mèng)dedecms使用SQL語(yǔ)句批量刪除指定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開(kāi)始，到2000; 大家可以自己設(shè)定;
| ? |
|
|
|
|||||||||||||||
| 全國(guó)咨詢熱線 | |||||||||||||||||
| 400-1100-266 | |||||||||||||||||
| 在線客服( QQ：340506921 ) | |||||||||||||||||
 |
|||||||||||||||||
