MySQL DELETe FROM以子查询为条件

您无法指定要删除的目标表。

解决方法

create table term_hierarchy_backup (tid int(10)); <- check data typeinsert into term_hierarchy_backup SELECt DISTINCT(th1.tid)FROM term_hierarchy AS th1INNER JOIN term_hierarchy AS th2 ON (th1.tid = th2.tid AND th2.parent != 1015)WHERe th1.parent = 1015;DELETe FROM term_hierarchy AS thWHERe th.parent = 1015 AND th.tid IN (select tid from term_hierarchy_backup);