INSERT VALUES statement

Creates one or more rows at specified times, and inserts them into a stream or window.

Syntax

insert_clause values_clause output_clause ;
Components

insert_clause

The destination of the specified values. See INSERT Clause for more information.

values_clause

The values to insert. See VALUES Clause for more information.

output_clause

When the values should be inserted. See OUTPUT Clause for more information.

Usage

The Insert Values statement produces rows of data at specified times and publishes them to its destination data stream or window. This statement executes only at the times specified by the OUTPUT clause.

Important:

In order for an Insert Values statement to produce output when you set synchronization to "Use message timestamp," a row must arrive on an input stream.

See Also

Example

This example inserts two rows of one column each into the Sites data stream when the project first starts running:

INSERT INTO Sites
VALUES ('New York'), ('London')
OUTPUT AT STARTUP;
Parent topic: Statements