8
Insertions
General form:
Missing attribute ® NULL.
May drop attribute names if give them in order.
 INSERT   INTO   R(A1,…., An)   VALUES  (v1,…., vn)
INSERT  INTO  Purchase(buyer, seller, product, store)
               VALUES  (‘Joe’, ‘Fred’, ‘wakeup-clock-espresso-machine’,
                                   ‘The Sharper Image’)
Example: Insert a new purchase to the database: