Skip to content

Instantly share code, notes, and snippets.

@slavic18

slavic18/clear wp tables for post and attachments

Created September 7, 2016 16:01
Show Gist options
  • Save slavic18/3f1cb6789c50da965a58a250730fec24 to your computer and use it in GitHub Desktop.
Save slavic18/3f1cb6789c50da965a58a250730fec24 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
clear wp tables for post and attachments
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 IN("post", "attachment")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment