Chapter 8, Problem 36P

Explanation of Solution

UPDATE command:

• The UPDATE command is employed to update information present in a table.
• It is always used with SET keyword either in bulk or individually.

Syntax for update the value in the table is given as follows:

UPDATE table_name

SET column1 = data1, column2 = data2, ...

WHERE condition;

Update values into the table “MODEL”:

Query 1:

UPDATE MODEL

SET MOD_WAIT_CHG = 100

WHERE MOD_CODE = 'C-90A';

Query 2:

UPDATE MODEL

SET MOD_WAIT_CHG = 50

WHERE MOD_CODE = 'PA23-250';

Query 3:

UPDATE MODEL

SET MOD_WAIT_CHG = 75

WHERE MOD_CODE = '...