MySQL Update statement with INNER JOIN

Question

I have no idea what the problem is. Any thoughts? I tried to update my first_q column from gradings table.

UPDATE gradings g set g.first_q = 90 FROM gradings
INNER JOIN subjects ss
on ss.subject_id = g.subject_id
INNER JOIN students s
ON s.id = g.student_id
INNER JOIN school_years sy
on sy.id = g.sy_id
INNER JOIN teachers t
on t.id = g.teacher_id
WHERE s.id = 1;

Do you get any error or what is your Problem? – Jens Oct 10 '16 at 13:32 — Jens, Oct 10 '16 at 13:32
Could you up vote my answer? – Wellington Lorindo Oct 10 '16 at 14:59 — Wellington Lorindo, Oct 10 '16 at 14:59

score 8 · Accepted Answer · edited Jul 18 '20 at 11:03

8

The syntax is wrong. Maybe you should try something like this:

UPDATE gradings g 
INNER JOIN subjects ss ON ss.subject_id = g.subject_id
INNER JOIN students s ON s.id = g.student_id
INNER JOIN school_years sy ON sy.id = g.sy_id
INNER JOIN teachers t ON t.id = g.teacher_id
set g.first_q = 90
WHERE s.id = 1;

MySQL Update Inner Join tables query

edited Jul 18 '20 at 11:03

Ankit Jindal

3,672
3
25
37

answered Oct 10 '16 at 13:37

Wellington Lorindo

2,405
19
21

Thank you! My syntax is wrong. – mrgx Oct 10 '16 at 13:48

score 0 · Answer 2 · answered Oct 10 '16 at 13:36

0

I believe you can just remove the FROM gradings and put the JOINs before the SET

answered Oct 10 '16 at 13:36

CptMisery

612
4
15

MySQL Update statement with INNER JOIN

2 Answers2