我尝试执行查询,但出现错误。这是我的查询:
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