Usage
Insert a single row into table films:

INSERT INTO films VALUES
(’UA502’,’Bananas’, 105 ,’ 1971 - 07 - 13 ’,’Comedy’,INTERVAL ’ 82  minute’);

In this second example the last column len is omitted and therefore it will have the default value of
NULL:

INSERT INTO films (code, title, did, date_prod, kind)
VALUES (’T_601’, ’Yojimbo’,  106 , DATE ’ 1961 - 06 - 16 ’, ’Drama’);

Insert a single row into table distributors; note that only column name is specified, so the omitted column
did will be assigned its default value:

INSERT INTO distributors (name) VALUES (’British Lion’);

Insert several rows into table films from table tmp:

INSERT INTO films SELECT * FROM tmp;