Skip to main content

INSERT

Creates a new instance or instances of a resource.

See also:
[ StackQL Resource Hierarchy ]

Syntax​

insertStatement::=

INSERTawaitQueryHintIGNOREINTOmultipartIdentifier'('fieldList')'selectStatementVALUES'('fieldList')'';'

 

INSERT [ /*+ AWAIT  */ ] [ IGNORE ] [ INTO ] <multipartIdentifier>
[ (field_name [, field_name] ...) { VALUES (field_name [, field_name] ...) | <selectExpression>; } ;

Examples​

Basic INSERT statement​

Run an INSERT statement to create a Compute Engine Disk resource. This is a non blocking (asynchronous) invocation.

-- Create a Compute Engine Disk resource
INSERT INTO google.compute.disks (project, zone, name, sizeGb) 
SELECT 'stackql-demo', 
'australia-southeast1-a', 
'test10gbdisk', 10;

INSERT statement (blocking)​

Run an INSERT statement to create a Compute Engine Disk resource. This is a blocking (synchronous) invocation.

-- Create a Compute Engine Disk resource
INSERT /*+ AWAIT  */ INTO google.compute.disks (project, zone, name, sizeGb) 
SELECT 'stackql-demo', 
'australia-southeast1-a', 
'test10gbdisk', 10;