You are here

UPDATE - modify data records



    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.


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.

Error | AAM


The website encountered an unexpected error. Please try again later.