UPDATE - modify data records

Syntax

Description:

    UPDATE is used to update some Values in the fields of a table with other Values.

SET { Fieldname=Value } [,...]

    With SET you scpecify the fields in which the values are replaced with the here specifyed values.

    Example:

UPDATE tverkauf
 SET prov = prov + .01
 WHERE 2 &lt=
 ( SELECT COUNT(knum) FROM tkunden WHERE tkunden.vnum=tverkauf.vnum );

Here is the field prov increased by .01 in all records of the table tverkauf, which have no more than 2 corresponding records in the tkunden table.