Introduce rows into a table.

An insert construct with a VALUE clause adds a row at a time to the table.

An insert construct with a subquery clause adds to the table all the rows returned by th subquery.

 

Example:

INSERT INTO

grade(scale, colour, desc)

VALUES('A', 'Black', 'Terrific')

 

Example:

INSERT INTO

grade

VALUES('A', 'Terrific', 'Black')

 

Example:

INSERT INTO

red_grades

SELECT scale, desc

FROM grade

WHERE grade.colour='Red';