SQL statement examples

INSERT INTO term (code,name,parent,scope) VALUES (
    819,
    'ocean temperature',
    810,
    'Includes discussion and measures of both in situ
    and potential temperature.  Distribution of heat
    in the oceans, including surface water, thermocline
    and mode waters, and deep waters.'
    );
INSERT INTO relterm (a,b) VALUES (819,68);
INSERT INTO relterm (a,b) VALUES (819,818);
INSERT INTO nonpref (code,name) VALUES (819,'temperature (ocean)');
INSERT INTO term (code,name,parent,scope) VALUES (
    1027,
    'sea surface temperature',
    819,
    'Includes temperature data obtained in situ
    or by remote sensing methods.  Observed
    temperature of surface ocean waters, typically
    encompassing the entire mixed layer but some
    observational methods may measure a much
    smaller depth range.'
    );
INSERT INTO relterm (a,b) VALUES (1027,74);
INSERT INTO nonpref (code,name) VALUES (1027,'temperature (sea surface)');