使用织梦CMS批量删除未审核文章或评论的SQL语法
织梦CMS批量删除未审核文章或评论的SQL语法如下: ```sql DELETE FROM dede_archives WHERE ismake=0 AND checkinfo='' AND id>0; DELETE FROM dede_addonarticle WHERE ismake=0 AND checkinfo='' AND id>0; DELETE FROM dede_arctiny WHERE ismake=0 AND checkinfo='' AND id>0; DELETE FROM dede_comment WHERE ismake=0 AND status=0; ``` 以上SQL语句分别用于删除未审核的文章、附加表文章、缩略图和未审核的评论。请注意,执行这些操作前请确保已备份数据,以防误删。
织梦CMS批量删除未审核文章或评论SQL语法
织梦dedecms后台-->系统-->SQL命令行工具-->运行下以命令即可
deletefrom'dede_archives'wherearcrank=-1;//批量删除未审核的文档deletefrom'dede_feedback'whereischeck=0;//批量删除未审核的评论
备注:请将表前缀修改为你自己的表前缀