删除所有草稿？

Question

这是删除所有post修订的常见查询：

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

这是否可以删除所有草案？

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'draft'

它是否比这更好，因为它也删除了postmeta？

 DELETE FROM posts WHERE post_status = ‘draft’

Answer 1

draft不是post_type，它是post_status。因此，您应该使用第二个代码块进行替换：

DELETE a,b,c
FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_status = 'draft'

Answer 2

我建议如果你想手动删除wp_posts中的任何帖子。您需要执行以下步骤：-

1. 从后置表中移除。

delete FROM wp_postmeta WHERE post_id IN
    (
        select id from wp_posts where post_status='draft'
    );

1. 从wp_term_relationships表中删除。

delete FROM wp_term_relationships WHERE object_id IN
    (
        select id from wp_posts where post_status='draft'
    );

1. 从wp_posts表中删除。

delete from wp_posts where post_status='draft'