您可能会收到此错误：
ERROR 1093 (HY000): You can't specify target table 'table_1' for update in FROM clause.
您应该能够使用MySQL的多表
DELETe语法来做到这一点：
DELETE table_1.*FROM table_1, table_2, table_3WHERe table_1.id = table_2.table_1_idAND table_2.id = table_3.table_2_idAND table_3.id = 5
上面的查询应该可以工作，但是作为一般规则，我建议使用ANSI JOIN语法代替：
DELETe table_1.*FROM table_1INNER JOIN table_2 on table_2.table_1_id = table_1.idINNER JOIN table_3 on table_3.table_2_id = table_2.idWHERe table_3.id = 5
