This statement is used to change values of existing data in the database.
Syntax:
UPDATE table_name
SET columnname1 = value1 [, columname2 = value2]...
WHERE search_condition;
This statement checks the WHERE clause first. For all records in the given table in which the WHERE clause evaluates to TRUE, the corresponding value is updated.
