none
load loads data as records in the current database and update values of each columns.
load values table [columns [ifexists [input_type]]]This section describes all parameters.
It specifies values loaded to records. Values should satisfy
input_typeformat. If you specify "json" asinput_type, you can choose a format from below:
Format 1:[[COLUMN_NAME1, COLUMN_NAME2,..], [VALUE1, VALUE2,..], [VALUE1, VALUE2,..],..]
Format 2:[{COLUMN_NAME1: VALUE1, COLUMN_NAME2: VALUE2}, {COLUMN_NAME1: VALUE1, COLUMN_NAME2: VALUE2},..]
[COLUMN_NAME1, COLUMN_NAME2,..]format inFormat 1is effective only whencolumnparameter isn't specified.When a target table contains primary key, you must specify
_keycolumn (pseudo column associated primary key) as the one ofCOLUMN_NAME.If
valuesisn't specified any values, they are read from the standard input until all opened parenthes match their closed ones.
You don't have to enclose them with single-quotes or double-quotes, but if you specified values with values parameter, you should do.
In following values, you also don't have to enclose any spaces (' ') with single-quotes or double-quotes.
table
It specifies a table name you want to add records.
columns
It specifies column names in added records with comma separations.
ifexists
It specifies executed
grn_exprstring when the same primary key as added records already exists in your table. Ififexistsspecifiesgrn_exprstring (default: true) and its value is true, values in other (all columns excluding_keycolumn) columns is updated.
input_type
It specifies an input format for
values. It supports JSON only.
Here is an example to add records to "Entry" table. :
load --table Entry --input_type json --values [{\"_key\":\"Groonga\",\"body\":\"It's very fast!!\"}]
[1]This example shows how to add values from standard input. :
load --table Entry --input_type json
[
{"_key": "Groonga", "body": "It's very fast!!"}
]
[1]
loadreturns the number of added records such as :[NUMBER]
/reference/grn_expr