Chapter 6, Problem 7SCG

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

The Syntax for update the value in the table is given below:

UPDATE table_name

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

WHERE condition;

“AND” operator:

The operator used to check two or more conditions using single query. The “AND” operator returns “true” when two conditions are satisfied in the query.