Question

当我使用这一询问时,MySQL向我展示了“HY000”错误:“你可以具体列出从条款中更新的目标表。

问题似乎是,问询和分局的目的似乎相同。

 <?php  $requete = $pdo->prepare( UPDATE msg_pv SET 
        lu=:lu
        WHERE id_ref_msg = :id_ref_msg AND date_message > ( SELECT MIN(date_message) FROM msg_pv WHERE id_ref_msg = :id_ref_msg AND lu="0" ) );

NOTE: I ve在有INNER JOIN的其他职位上读过一些解决办法,但表格不同。

Answer 1

类似情况

UPDATE
  msg_pv AS t1
CROSS JOIN (
  SELECT MIN(date_message) AS date_message FROM msg_pv
  WHERE id_ref_msg = :id_ref_msg AND lu="0"
) AS t2
SET
  t1.lu = :lu
WHERE
  t1.date_message > t2.date_message

友情链接