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

0 vote265 views2 answers
Nested query
SQL
0 vote272 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
10 votes249 views1 answer
Dba_dependencies
SQL
20 votes271 views1 answer
Sql change column types
SQL
0 vote248 views1 answer
Bash block size ls /var/lib/mysql
SQL
5 votes252 views2 answers
Oracle show procedures
SQL
0 vote261 views1 answer
See Foreign Key
SQL
3 votes253 views1 answer
Oracle undo tablespace list by user
SQL
0 vote263 views1 answer
List mysql tables and views
SQL
8 votes252 views1 answer
How to remove tables from postgresql
SQL