Skip to content

Instantly share code, notes, and snippets.

@dingo-d

dingo-d/delete.sql

Created November 17, 2017 09:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dingo-d/92663935fd8086deb9b8f882958ed8b0 to your computer and use it in GitHub Desktop.
Save dingo-d/92663935fd8086deb9b8f882958ed8b0 to your computer and use it in GitHub Desktop.
Download ZIP
Delete all the posts with their asocciated postmeta in the database
Raw
delete.sql
DELETE p, pm FROM wp_posts p JOIN wp_postmeta pm ON p.ID = pm.post_id WHERE p.post_type = 'post'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment