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

4 votes300 views2 answers
Show all database inside postgresql
SQL
0 vote284 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote301 views1 answer
Why we have to set the password for my sql server
SQL
0 vote285 views2 answers
Mysql add days to date
SQL
0 vote276 views1 answer
Oracle select invalid views
SQL
2 votes290 views1 answer
Oracle sql day of month from date
SQL
0 vote295 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote295 views1 answer
Mysql group by range
SQL
1 vote286 views1 answer
Increase date by one day in sql oracle
SQL
0 vote308 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL