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 votes285 views2 answers
Sql lag
SQL
0 vote242 views1 answer
Sum sqlserver
SQL
0 vote270 views2 answers
Postgresql change user role grant
SQL
4 votes248 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote206 views1 answer
Connection error in mysql workbench
SQL
0 vote255 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
19 votes278 views3 answers
How to change column type psql
SQL
0 vote255 views1 answer
Sql delete dastabase
SQL
3 votes268 views1 answer
Oracle list dates without weekends
SQL
4 votes246 views1 answer
To date oracle with time
SQL