What is the result of the query shown in the example?
UPDATE Review
SET Comment = ‘This is the new comment’
WHERE MovieId = 3456 AND AuthorName = ‘PuzoFan76’;
- The comment made by PuzoFan76 for the movie with the ID 3456 will be modified to say, “This is a new comment.”
- A new comment will be added to the movie with the ID 3456 for the author PuzoFan76.
- All of the comments for the movie with the ID 3456 will be modified to say, “This is a new comment.”
- A new row will be added to the table Review with the MovieId= 3456 and the AuthorName =PuzoFan76.
| Answers Explanation & Hints:
The UPDATE command will modify an or multiple attributes in an existing record. You must use the INSERT command to add a new record to the table. If no WHERE clause is specified, the UPDATE command will update the attribute in all records in the table. |