php - 多表删除查询不起作用

Question

我有一个包含 3 个表的数据库，我试图通过一个查询从所有这些表中删除。

查询:

DELETE FROM cranes 
JOIN craneparts ON cranes.id = craneparts.craneID 
JOIN parts ON parts.id = craneparts.partsID 
WHERE cranes.id = '$id'`

任何人都可以帮助解决此查询为何不起作用的问题吗？ $id 只是一个 PHP 整数，为了我的测试目的，$id = 2

给定的错误是:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'JOIN craneparts ON cranes.id = craneparts.craneID JOIN parts ON parts.id = crane' at line 1`]

Answer 1

您的查询必须具体说明您希望它从哪些表中删除，即使您想要从所有表中删除也是如此。

DELETE cranes, craneparts, parts
FROM cranes JOIN craneparts ON cranes.id = craneparts.craneID 
JOIN parts ON parts.id = craneparts.partsID 
WHERE cranes.id = '$id'

参见 http://dev.mysql.com/doc/refman/5.6/en/delete.html获取更多文档。