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

1 vote110 views1 answer
Window function mysql
SQL
0 vote100 views1 answer
Oracle create package body
SQL
0 vote118 views2 answers
How to generate a unique random number in mysql
SQL
0 vote112 views1 answer
Get time component of datetime sql
SQL
0 vote110 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote112 views1 answer
Reona
SQL
0 vote100 views1 answer
Python mysql query where
SQL
0 vote134 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes156 views2 answers
Postgres drop column if exists
SQL
0 vote108 views2 answers
Mysql to python pandas
SQL