mysql批量删除dedecms指定栏目下所有文章及栏目

如何利用mysql批量删除dedecms指定栏目下所有文章（栏目），下面编程教程网小编给大家简单介绍一下！

具体语法如下：

//删除所有栏目为3-10之间的所有文章及栏目
delete from dede_addonarticle where typeid >= 3 and typeid <= 10; 
delete from dede_arctiny where typeid >= 3 and typeid <= 10; 
delete from dede_archives where typeid >= 3 and typeid <= 10; 
delete from dede_arctype where id >= 3 and id <= 10;

Ps:操作之前请先备份数据库，以免删错~