Question

In Marks column of ‘Student’ table, for Rollnumber 2, the Class Teacher entered the marks as 45. However there was a totaling error and the student has got her marks increased by 5. Which MySQL command should she use to change the marks in ‘Student’ table.

Answer 1

UPDATE Student SET Marks = 50 WHERE Roll number = 2;