Skip to content

Instantly share code, notes, and snippets.

@n1k1c4

n1k1c4/wc_delete_all_categories.sql

Last active December 8, 2017 10:29
Show Gist options
  • Save n1k1c4/2dba8d4ef314271a987d6b1d49e514e9 to your computer and use it in GitHub Desktop.
Save n1k1c4/2dba8d4ef314271a987d6b1d49e514e9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
wc_delete_all_categories.sql
DELETE a,c FROM wp_terms AS a
LEFT JOIN wp_term_taxonomy AS c ON a.term_id = c.term_id
LEFT JOIN wp_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
WHERE c.taxonomy = 'product_cat'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment