SQL命令删除WordPress文章修订历史版本数据

· WordPress · 42 views

要删除WordPress文章修订历史版本数据，手动执行以下SQL命令：

DELETE FROM wp_postmeta WHERE post_id IN (SELECT id FROM wp_posts WHERE post_type = 'revision');
DELETE FROM wp_term_relationships WHERE object_id IN (SELECT id FROM wp_posts WHERE post_type='revision');
DELETE FROM wp_posts WHERE post_type='revision';