The UPDATE query is used to modify attribute values of one or more selected tuples, a WHERE clause is used to select the tuples to be modified. An additional SET clause specifies attributes to be modified and their new values.
UPDATE <table>
SET <attribute>=<value>, ...
WHERE <condition>Referential integrity should be enforced. Each command modifies tuples in the same relation.