Skip to content

Instantly share code, notes, and snippets.

@deadlyhifi

deadlyhifi/delete.sql

Created August 2, 2015 11:01
Show Gist options
  • Save deadlyhifi/13a8a04b420e1208e62f to your computer and use it in GitHub Desktop.
Save deadlyhifi/13a8a04b420e1208e62f to your computer and use it in GitHub Desktop.
Download ZIP
WP Delete Post Revisions
Raw
delete.sql
DELETE
FROM wp_posts
WHERE post_type = 'revision';
DELETE FROM wp_postmeta
WHERE post_id NOT IN (SELECT ID FROM wp_posts);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment