Describes purpose and syntax of the UPDATE statement
The
UPDATE statement modifies a set of field values in each row which satisfies a given search condition. If no row matches the condition, the
UPDATE will have no effect.
Note: In the syntax and example sections below, SQL keywords appear in
all caps. This is an SQL convention and it is not required by Studio. However, it is useful to help differentiate SQL commands from regular code.
Syntax:
UPDATE <table_name>
SET <column_name1> = <value-expression1>,
<column_name2> = <value-expression2>,
...
[WHERE <condition>]
For example, the following
UPDATE increases the salary by 10% for all employees who earn less than $25,000:
UPDATE employee
SET salary = salary * 1.1
WHERE salary < 25000
Note: If the WHERE condition is not specified, all the rows will be updated.