SQL命令：DEDE删除非审核的文档

SQL命令：DEDE删除非审核的文档

DELETE from dede_archives where arcrank=-1;

DELETE dede_addonarticle
from dede_addonarticle
left join dede_archives   on dede_addonarticle.aid=dede_archives.id
where dede_archives.id is null

DELETE dede_arctiny
from dede_arctiny
left join dede_addonarticle   on dede_arctiny.id=dede_addonarticle.aid
where dede_addonarticle.aid is null

原创文章如转载，请注明：转载自imseoer.cn