UPDATE
UPDATE
SQLite Language Reference Documentation
See Also
Example
Collapse All
Expand All
SQL As Understood By SQLite
UPDATE
sql-statement ::=
UPDATE [ OR
conflict-algorithm
] [ color="#ff3434">database-name .] color="#2c2cf0"> table-name color="#2c2cf0">
SET assignment
[,
assignment]* color="#2c2cf0">
[WHERE expr color="#2c2cf0">]
assignment ::=
column-name color="#2c2cf0"> = expr color="#2c2cf0">
The UPDATE statement is used to change the value of columns in selected rows of
a table. Each assignment in an UPDATE specifies a column
name to the left of the
equals sign and an arbitrary expression to the right. The expressions may use the
values of
other columns. All expressions are evaluated before any assignments are
made. A WHERE clause can be used to restrict which rows are updated.
The optional conflict-clause allows the specification of an alternative constraint conflict resolution algorithm to use during this one command. See the section titled
ON CONFLICT for additional information.
