Chapter 5, Problem 2HOA

Explanation of Solution

UPDATE command:

User must use UPDATE command to change the existing data in a table. UPDATE command belongs to DML (Data Manipulation Language) statement.

Syntax: UPDATE tablename SET columnname=new data value,....;

• UPDATE keyword in a statement identifies the table containing records to be changed.
• SET keyword identifies the column(s) data to be changed with new values to be assigned to the columns...