Delete all SQL statements to be reviewed by zhimeng

Remind me first

Archives is the dedecms master table.
Addonarticle news info table

Run the following command in the dede background "system-" SQL command line tool "(Note: All unaudited data is deleted after running. Be careful when using this command)

The Code is as follows:
Delete from 'dede _ archives 'where arcrank =-1; // www.111cn.net
 

Run phpmyadmin

SQL statements help you delete all unaudited documents in dede background

Lx is the table prefix.

The 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 of the getting together tutorial thinks that the deletion is cleaner later, because the latter deletes the data waiting for review in all tables.

For more details, see: http://www.111cn.net/wy/CMS/58157.htm