SQL Update

Code

UPDATE Math_Results
SET Marks=80
WHERE marks=79;

EXPLANATION

This update query will update the table Math_Results and set the marks of all students to 80 who secured 79 marks.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at WordPress.com.

Up ↑

Create your own website, free on WordPress.com.Create your own website.
Start free