Skip to content

Instantly share code, notes, and snippets.

@nawawi

nawawi/remove_orphan_post.sql

Last active September 26, 2022 07:48
Show Gist options
  • Save nawawi/836132a39f1ea780b80927575af22a31 to your computer and use it in GitHub Desktop.
Save nawawi/836132a39f1ea780b80927575af22a31 to your computer and use it in GitHub Desktop.
Download ZIP
MySQL trigger to remove wp orphan post
Raw
remove_orphan_post.sql
-- Replace wp_postmeta and wp_posts with your prefix table
CREATE TRIGGER `remove_orphan_post` AFTER DELETE ON `wp_posts`
FOR EACH ROW BEGIN IF ('post' = old.post_type) THEN
DELETE FROM wp_postmeta WHERE wp_postmeta.post_id = old.ID;
END IF; END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment