UPDATE STATEMENT

ü  UPDATE statement is used to change the existing data.

ü  It is used to update the row(s) in the table of existing database.

ü  It is used to update the row(s) in the table based on where clause.

Syntax:

UPDATE Table1
SET Col1 = Val1, Col2 = Val2
WHERE Col3 =Val3

Example:

Note:

·         It can be used with ‘AND’ or ‘OR’ clause.