# groonga - An open-source fulltext search engine and column store.

- 日本語

# 7.3.24. `load`

## 7.3.24.1. Summary

`load` loads data as records in the current database and updates values of each columns.

## 7.3.24.2. Syntax

    load values table [columns [ifexists [input_type]]]

## 7.3.24.3. Parameters

This section describes all parameters.

`values`

> 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 `columns` 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`

> Specifies a table name you want to add records.

`columns`

> Specifies column names in added records with comma separations.

`ifexists`

> 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`

> Specifies an input format for `values`. It supports JSON only.

## 7.3.24.4. Usage

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]

## 7.3.24.5. Return value

### 7.3.24.5.1. JSON format

> `load` returns the number of added records such as

>     [NUMBER]

## 7.3.24.6. See also

grn_expr