Syntax error in mySQL Update-Query

Question

I try to execute the query but get an error. This is my query:

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

and I get the error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM prepares_for_exam, product WHERE prepares_for_exam.id = product.prepares_fo' at line 1

I did the Update Query 100-times with an FROM clause and never had problems... Whats my fault?!?

juergen d · Accepted Answer · 2015-07-15 16:07:03Z

1

You are using the SQL-Server syntax. In MySQL it is a little bit different.

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

answered Jul 15, 2015 at 16:07

juergen d

205k40 gold badges303 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vamsi Prabhala · Accepted Answer · 2015-07-15 16:07:21Z

0

UPDATE 
prepares_for_exam 
SET 
prepares_for_exam.exam_id = (select product.id FROM 
prepares_for_exam JOIN product on prepares_for_exam.id = product.prepares_for_exam_id)

answered Jul 15, 2015 at 16:07

Vamsi Prabhala

49.4k4 gold badges41 silver badges64 bronze badges

Collectives™ on Stack Overflow

Syntax error in mySQL Update-Query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related