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;

如图所示:

 

SLQ命令:DeDeCMS织梦清空所有文章SQL语句