» Documentation » SQL Reference

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 expressions.