用pdo更新内部连接查询

Question

我试图用一个查询更新两个表，但是它没有更新，也没有显示任何错误。这是代码

$id_prod = 2;
$id_cust = 2;
$sql5 = "UPDATE `customer` 
           INNER JOIN `products` ON products.cust_id=customer.id 
         SET prod_name = 'CAKE' AND name = 'Hassan' 
         WHERE id='$id_cust' AND id='id_prod' ";
$query5 = $conn->prepare($sql5);
$query5->execute(array($id_cust, $id_prod));

​

​

​

​

Answer 1

可能要设置的列名称有误，如果在列名前面加上表名，这更好吗？

就像这样：

$id_prod = 2;
$id_cust = 2;
$sql5 = "UPDATE `customer` 
           INNER JOIN `products` ON products.cust_id=customer.id 
         SET __tableName__.prod_name = 'CAKE' AND __tableName__.name = 'Hassan' 
         WHERE __tableName__.id='$id_cust' AND __tableName__.id='id_prod' ";
$query5 = $conn->prepare($sql5);
$query5->execute(array($id_cust, $id_prod));