We have the
students table again. Let’s say we decide to enroll all students who have scored more than
80 marks in the
Ruby course, and promote all of them to grade
To solve this, the
UPDATE statement can also be used to update multiple columns.
To update multiple columns, we simply need to add multiple expressions to the
SET list, separated by