Update (SQL)

Change the existing field values in a table.

Syntax
      UPDATE table SET newvalue WHERE criteria;

Key
  table     The name of the table to modify.

  newvalue  An expression that determines the value to be
            updated in a specific field in the table.

  criteria  An expression that determines which records
            will be updated.

Multiple records can be updated together, or the criteria can limit the update to a single row.
Several fields can be updated at the same time.

Example:

UPDATE Orders
SET OrderAmount = OrderAmount * 1.1, Freight = Freight * 0.9
WHERE ShipCountry = 'UK';

“Even God cannot change the past” ~ Agathon

Related:

Delete - Delete records.
Execute (SQL/VBA) - Execute a procedure or run SQL.
Insert - Add records to a table (append query).
Select - Retrieve data from one or more tables or queries.
Select Into - Make-table query.
Select-Subquery - SubQuery
Transform - Create a crosstab query.
Union - Combine the results of two SQL queries.
Update - Update existing field values in a table.


© Copyright SS64.com 1999-2014
Some rights reserved