Chapter 1, Problem 3TD

Program Plan Intro

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 to update the value in the table is given as follows:

UPDATE table_name

SET column1 = data1, column2 = data2,

WHERE condition;