See Also
You are here: SQL Reference > Data Manipulation > INSERT
ContentsIndexHome
PreviousUpNext
INSERT
INSERT

 

Syntax

INSERT INTO table_path [(column_name [, ...])]
  VALUES (expression [, ...])
INSERT INTO table_path (SELECT STATEMENT)

 

Description 

Adds a new row to the table at table_path comprised of the VALUES specified. The expressions in the select list are used to produce the row data. They can be any combination of internal functions and arithmetic operators on constants and valid column_names produced by the table_path

 

Subqueries are not valid in INSERT expressions. 

 

 

Related