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 vote132 views3 answers
Mysql Server Start
SQL
0 vote131 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
11 votes139 views1 answer
Ddl view
SQL
5 votes155 views2 answers
Get columns number sql
SQL
0 vote125 views2 answers
Find Overlapping sql
SQL
0 vote282 views1 answer
Hue hive UploadingTextFiletoHive
SQL
5 votes144 views4 answers
Change auto increment mysql
SQL
8 votes126 views2 answers
Phpmyadmin default password
SQL
0 vote148 views1 answer
Zsh: command not found: mysql mamp
SQL
1 vote135 views1 answer
Moodle query first user access
SQL