mysql - 删除 2 个表的查询不起作用

Question

public function deleteCustomerFunc($CustID)
{   
    $sql = "DELETE customer, cargo
    FROM customer AS cust, cargo AS car
    WHERE cust.CustID = car.CustID
    AND CustID='$CustID'";

    $result = mysql_query($sql);
    return $result;
}

我有 2 个表:

1)客户-CustID-主键2)Cargo-id-primary key,CustID=Foreign key

Answer 1

特定的错误消息会有所帮助。但是，我最初的猜测是您的 AND 子句不明确 - CustID 可以指 cust 或 car 表。虽然在这种情况下使用哪一个并不重要，但解释器并不知道这一点，您需要指定其中一个。

public function deleteCustomerFunc($CustID)
{   
    $sql = "DELETE customer, cargo
    FROM customer AS cust, cargo AS car
    WHERE cust.CustID = car.CustID
    AND cust.CustID='$CustID'";

    $result = mysql_query($sql);
    return $result;
}