SQL命令:DeDeCMS织梦清空所有文章SQL语句
织梦程序删除太多文档一页一页勾选删除太慢,以下我们介绍SQL命令工具,一键操作删除所有文档,操作命名之前,做好数据库备份工作。
操作步骤:
1:登录后台--系统--SQL命令工具
2:输入:
DELETE FROM dede_addonarticle WHERE aid >= 1 and aid< =5000;
DELETE FROM dede_arctiny WHERE id >= 1 and id< =5000;
DELETE FROM dede_archives WHERE id >= 1 and id<=5000;
如图所示: