Recently engaged in Dede collection, mention weaving dream believe that we are not unfamiliar, I in the first time to collect, because will not write rules, and is not a separate collection of an article, but the list of articles in a one-time all collection, and other export data, I and the small partners are stunned, collected the news almost are missing arms and legs, At the beginning is also an article of the deletion, it is very annoying, however, the following SQL statement has helped me a lot, one-time to empty the Recycle Bin.
I hope to be helpful to those who have the same experience with me, with the following statement:
Method:
Run in the System->sql command-line tool in the background:
Delete dede_addonarticle,dede_archives,dede_arctiny from Dede_addonarticle,dede_archives,dede_arctiny where Dede_ Addonarticle.aid=dede_archives.id and Dede_arctiny.id=dede_archives.id and dede_archives.arcrank= '-2 '
But I want to delete all the articles under the column how to delete it? I believe you have encountered this situation, the steps are as follows:
Into the background--core--Batch maintenance--Document batch Maintenance
: 650) this.width=650; "src=" http://www.yunda51.com/wp-content/uploads/2013/09/2211.jpg "title=" 2211 "class=" Alignnone size-full wp-image-1003 "style=" Vertical-align:text-bottom;margin:0px;padding:0px;border:0px;height: auto; "height=" 221 "width=" 721 "/>
Click Delete document, this step is complete!
This article is from "Playing Linux ... Do operation and maintenance ... Cluster "blog, be sure to keep this provenance http://scottlinn.blog.51cto.com/829656/1618084
Dede Dream System One-click Empty Recycle Bin and bulk Delete all article methods