My query:
DELETE FROM 014_terms WHERE term_id IN (SELECT term_id FROM 014_term_taxonomy WHERE taxonomy LIKE 'pa_%');
Gets an error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE term_id IN (SELECT term_id FROM 014_term_taxonomy WHERE taxonomy LIKE '...' at line 1
Any ideas what is causing the error?
from Databases https://ift.tt/3mLxOR5
via IFTTT

0 Comments