×
Night mode
Sign up
Login
UPDATE another table using explicit JOIN
Updates students table based on notes table column - 
notes.id
using 
explicit JOIN
UPDATE notes
INNER JOIN students ON notes.student_id = students.id
SET students.points = students.points + 1
WHERE notes.id = 1
by Valeri Tandilashvili
4 years ago
MySQL
UPDATE
1
Pro tip: use ```triple backticks around text``` to write in code fences