我尝试执行查询,但出现错误。这是我的查询:

UPDATE
    prepares_for_exam
SET
    prepares_for_exam.exam_id = product.id
FROM
    prepares_for_exam,
    product
WHERE
    prepares_for_exam.id = product.prepares_for_exam_id


我得到错误:


  您的SQL语法有误。在第1行的“ FROM prepares_for_exam,产品WHERE prepares_for_exam.id = product.prepares_fo”附近,查看与您的MySQL服务器版本相对应的手册,以使用正确的语法。


我使用FROM子句进行了100次更新查询,但从未遇到问题...我的错是什么?!?

最佳答案

您正在使用SQL-Server语法。在MySQL中,它有所不同。

UPDATE
    prepares_for_exam
JOIN
    product
ON
    prepares_for_exam.id = product.prepares_for_exam_id
SET
    prepares_for_exam.exam_id = product.id

10-05 20:28
查看更多