- NAME
-
- gcloud spanner rows insert - insert a row in a Cloud Spanner database
- SYNOPSIS
-
-
gcloud spanner rows insert
--data
=[COLUMN_NAME
=VALUE
,…]--table
=TABLE
(--database
=DATABASE
:--instance
=INSTANCE
) [GCLOUD_WIDE_FLAG …
]
-
- EXAMPLES
-
To insert a row with SingerId=1,SingName=abc in table Singers under my-database
and my-instance, run:
gcloud spanner rows insert --table=Singers --database=my-database --instance=my-instance --data=SingerId=1,SingerName=abc
gcloud spanner rows insert --table=Singers --database=my-database --instance=my-instance --flags-file=path/to/file.yaml
- REQUIRED FLAGS
-
--data
=[COLUMN_NAME
=VALUE
,…]-
The column names and values for the row being added. For complicated input
values, such as arrays, use the
--flags-file
flag. See $ gcloud topic flags-file for more information. --table
=TABLE
- The Cloud Spanner table name.
-
Database resource - The Cloud Spanner database in which to insert a row. The
arguments in this group can be used to specify the attributes of this resource.
(NOTE) Some attributes are not given arguments in this group but can be set in
other ways.
To set the
project
attribute:-
provide the argument
--database
on the command line with a fully specified name; -
provide the argument
--project
on the command line; -
set the property
core/project
.
This must be specified.
--database
=DATABASE
-
ID of the database or fully qualified identifier for the database.
To set the
database
attribute:-
provide the argument
--database
on the command line.
This flag argument must be specified if any of the other arguments in this group are specified.
-
provide the argument
--instance
=INSTANCE
-
The Cloud Spanner instance for the database.
To set the
instance
attribute:-
provide the argument
--database
on the command line with a fully specified name; -
provide the argument
--instance
on the command line; -
set the property
spanner/instance
.
-
provide the argument
-
provide the argument
- GCLOUD WIDE FLAGS
-
These flags are available to all commands:
--access-token-file
,--account
,--billing-project
,--configuration
,--flags-file
,--flatten
,--format
,--help
,--impersonate-service-account
,--log-http
,--project
,--quiet
,--trace-token
,--user-output-enabled
,--verbosity
.Run
$ gcloud help
for details. - NOTES
-
These variants are also available:
gcloud alpha spanner rows insert
gcloud beta spanner rows insert
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-02-06 UTC.
[{
"type": "thumb-down",
"id": "hardToUnderstand",
"label":"Hard to understand"
},{
"type": "thumb-down",
"id": "incorrectInformationOrSampleCode",
"label":"Incorrect information or sample code"
},{
"type": "thumb-down",
"id": "missingTheInformationSamplesINeed",
"label":"Missing the information/samples I need"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
{
"last_modified": "Last updated 2024-02-06 UTC.",
"state": ""
}