Shulou(Shulou.com)06/02 Report--

Delete the unapproved manuscript of Weaving Dream. How to write the sql sentence? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

What is the sql statement to delete the unapproved manuscript of Zhimeng?

Just a reminder.

Archives is the dedecms master table

Addonarticle News Information sheet

Run the command under the "system"-"SQL Command Line tool" in the dede background (note that all unaudited data is deleted after running, use carefully)

The code is as follows:

Delete from `dede_ Archives` where arcrank=-1

Run in phpmyadmin

A sql statement helps you delete all the manuscripts to be reviewed in the dede background and delete all the unaudited documents

Lx is the prefix of the table

The code is as follows

DELETE `FROM `lx_ archives`LEFT JOIN `lx_ addonarchives`ON `lx_ archives`.id = `lx_ addonarchives`.aid WHERE `lx_ archives`.arcrank ='- 1' thank you for reading! After reading the above, do you have a general understanding of how to delete the manuscript sql of Weaving Dream? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.