UPDATE is used to modify data.
UPDATE <table_name>
SET <column_expressions>
[ WHERE <condition> ]- table_name
The table that will have its object modified. If the table does not exist (i.e. has no records) then no records will be updated since tables only come into existence when they have objects added to them.
- column_expressions
<column_name1> = <expression1>, ...
A list of columns to be updated by an expression.
name = "Bob", something_else = 3 + 5 * 2
You may use any value of the record in the expression as well:
counter = counter + 1, old_value = counter - 1
- condition
A filter expression. If no WHERE clause is provided then all objects in the table will be updated.