Rermove categories woocommerce 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_tag';

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'

Source: jonasrafael.com

Similar codes

2 votes180 views1 answer
SELECT INTO
SQL
22 votes234 views1 answer
Mysql workbench
SQL
0 vote189 views1 answer
Initcap in mysql
SQL
3 votes193 views1 answer
Async await mysql nodejs
SQL
2 votes162 views1 answer
Oracle current date without time
SQL
2 votes249 views1 answer
Merge two columns in sql oracle
SQL
0 vote180 views1 answer
Json not contains mysql
SQL
3 votes175 views1 answer
Uppercase and lowercase in sql
SQL
0 vote253 views1 answer
Mysql sum per week
SQL
4 votes213 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL