把下面10 改为你要删掉的栏目ID ,仔细看 不然删错就不好了

delete from dede_archives where typeid=10;
delete from dede_arctiny where typeid=10;
delete from dede_addonarticle  where typeid=10;

删除某个id段的文章,比如你要伤处id=100到id=5000,这个id段的文章如何删除嘞,方法如下:

DELETE FROM dede_addonarticle WHERE aid >= 100 and aid< =5000;
DELETE FROM dede_arctiny WHERE id >= 100 and id< =5000;
DELETE FROM dede_archives WHERE id >= 100 and id<=5000;

这样就删除掉了id100到5000的文章了。

发表评论