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 vote275 views1 answer
Join creating duplicate columns sqllite
SQL
2 votes306 views1 answer
Select a certain number of entries from select mysql
SQL
2 votes288 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote283 views1 answer
Sql change column in existing table
SQL
0 vote275 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote256 views1 answer
Describe in sqlite3
SQL
0 vote261 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
0 vote297 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
1 vote266 views1 answer
How to make a select in sql
SQL
2 votes279 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL