INSERT - store data in table

Syntax

Description:

    INSERT INTO inserts new records into the with Tablename specifyed table, which are consiting of fixed Values or are the result of a SELECT-Command.

    Example:

INSERT INTO tberlin
 SELECT *
 FROM tverkauf
 WHERE stadt='Berlin'

Here are all records from the table tverkauf inserted into the table tberlin, where stadt is equal to Berlin.

VALUES ( Value [,...] )

    With the VALUES keyword you can insert a new fixed value record into the database table.

    Example:

INSERT INTO tverkauf (vnum,vname,stadt)
 VALUES ( 1001, 'Müller', 'Berlin' );

Here is a new record, consisting of 1001,'Müller','Berlin',NULL , inserted into the table tverkauf.