previous | index | next

Populating a Table

Basic syntax:
   INSERT INTO table VALUES (value1, value2, ...); 

Examples:

   INSERT INTO pet VALUES ('Fluffy',  'Harold',  'cat',  'f',  
                           '1993-02-04', NULL);

   INSERT INTO pet VALUES ('Claws',  'Gwen',  'cat',  'm',  
                           '1994-03-17', NULL);

Note the use of the NULL keyword for missing data.


previous | index | next