load loads data as records in the current database and updates values of each columns.
日本語版はこちらload values table [columns [ifexists [input_type]]]
This section describes all parameters.
values
It specifies values loaded to records. Values should satisfy input_type format. If you specify "json" as input_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 in Format 1 is effective only when column parameter isn't specified.
When a target table contains primary key, you must specify _key column (pseudo column associated primary key) as the one of COLUMN_NAME.
If values isn'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_expr string when the same primary key as added records already exists in your table. If ifexists specifies grn_expr string (default: true) and its value is true, values in other (all columns excluding _key column) 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]