INSERT
Creates a new instance or instances of a resource.
See also:
[ StackQL Resource Hierarchy ]
Syntax
insertStatement::=
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;