Home>Article>CMS Tutorial> What is the sql statement to delete all manuscripts pending review in DreamWeaver?

What is the sql statement to delete all manuscripts pending review in DreamWeaver?

藏色散人
藏色散人 Original
2019-12-02 11:09:31 2326browse

What is the sql statement to delete all manuscripts pending review in DreamWeaver?

What is the sql statement to delete all manuscripts to be reviewed by Dreamweaver?

First of all, please remind me

archives is the dedecms main table

addonarticle news information table

Recommended study:伟梦cms

Just run the command in dede background "System-"SQL command line tool" (note that all unaudited data will be deleted after running, use with caution)

The code is as follows:

delete from `dede_archives` where arcrank=-1;

Run

sql statements in phpmyadmin to help you delete all manuscripts to be reviewed in the dede background and all unreviewed documents to be deleted

lx is the table The prefix

code is as follows

DELETE `lx_archives`.*,`lx_addonarticle`.* FROM `lx_archives` LEFT JOIN `lx_addonarticle` ON `lx_archives`.id = `lx_addonarticle`.aid WHERE `lx_archives`.arcrank = '-1'

The editor thinks that the later deletion is cleaner, because the latter deletes all data waiting for review in the table.

The above is the detailed content of What is the sql statement to delete all manuscripts pending review in DreamWeaver?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn