Choose your database:

Partners

Customers

Become a customer

SQL Maestro Group / Products / SQLite / SQLite Code Factory / Documentation

Download

Buy

SQLite Code Factory online Help

Return to chapter overview

sql-statement ::=

UPDATE [ OR conflict-algorithm ] table-name

SET assignment [, assignment]

[WHERE expr]

assignment ::=

column-name = expr

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.

Return to chapter overview

SQL Maestro Group wishes you a happy Thanksgiving!

We are pleased to grant you a 20% discount for all our products and bundles till the end of November!

News

Apr 10, 2017

Code Factories advanced to version 17.4

New version features colored tabs, new encryption algorithms in data grids, enhanced data input forms, updated data export/import tools and a lot of other useful things.

Sep 20, 2013

Code Factories are updated to version 13.9

New version comes with keyboard interactive SSH authentication, updated Script Runner, redesigned start page, improved SQL editors and data grids, as well as with many other useful things.

Mar 5, 2012

Code Factories advanced to version 12.3

New version introduces Unicode support in editors, updated code folding appearance, viewing BLOB data as PDF, data import from ODBC data source, Spanish translation and a lot of other new features.

More news

Feature of the day

Data Import

With SQLite Code Factory you can import data from Excel, CSV, text files and more.

Syntax highlighting

SQLite Code Factory provides syntax highlighting to prevent mistakes in syntax at once.

SQLite Code Factory online Help

UPDATE

Thanksgiving Sale