You are here

UPDATE - modify data records

Error message

Notice: unserialize(): Error at offset 1842 of 1865 bytes in variable_initialize() (line 1202 of /is/htdocs/wp1033310_AQAMEFYCW9/www/includes/



    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.