Fewpal
0 votes
31 views
in Information Technology by (47.6k points)
closed by

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.

1 Answer

+1 vote
by (52.3k points)
selected by
 
Best answer

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

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...