Updates another table using Implicit JOIN
Updates students table based on notes table column -
notes.id
using
implicit JOIN
UPDATE notes, students
SET points = points+1
WHERE notes.student_id = students.id
	AND notes.note = 'My first note'
by Valeri Tandilashvili
4 years ago
MySQL
UPDATE
1
Pro tip: use ```triple backticks around text``` to write in code fences