Use this statement to modify rows in a table.

Syntax

UPDATE table-name
SET column-name  = expression, ...
[ WHERE search-condition ]

Parameters

table-name   The table-name specifies the name of the table to update. Only a single table is allowed.

SET clause   Each named column is set to the value of the expression on the right-hand side of the equal sign. There are no restrictions on the expression . If the expression is a column-name, the old value is used.

Only columns specified in the SET clause have their values changed. In particular, you cannot use UPDATE to set a column's value to its default.

WHERE clause   If a WHERE clause is specified, only rows satisfying search-condition are updated. See Search conditions in UltraLite.

Remarks

The UPDATE statement modifies values in a table.

Character strings inserted into tables are always stored in the same case as they are entered, regardless of whether the database is case sensitive.

See also

• UltraLite INSERT statement
• UltraLite DELETE statement
• Search conditions in UltraLite

Example

The following statement transfers employee Philip Chin (employee 129) from the sales department to the marketing department (department 400).

UPDATE Employees
SET DepartmentID = 400
WHERE EmployeeID = 129;