— 删除冗余数据。仅删除 wp_posts 表中的修订版本。
DELETE FROM wp_posts WHERE post_type = ‘revision’;
删除自动草稿冗余数据。
DELETE FROM wp_posts WHERE post_status = ‘auto-draft’;
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=’auto-draft’ or a.post_type = ‘revision’;