UPDATE statement in RDBMS

UPDATE statement  allows you to update a single or multiple record in a table.

Syntax-
UPDATE table
SET column=expression
WHERE predicates;

Example

UPDATE supplier
SET name='HP'
WHERE name='IBM'