Console - INSERT

Inserts a new record into the current database. Remember, OrientDB can work in schema-less mode, meaning that you can create any field on the fly.

Syntax


1. INSERT INTO <<class-name>|CLUSTER:<cluster-name>> (<field-names>) VALUES ( <field-values> )
  • <class-name> Defines the class you want to create the record in.
  • CLUSTER:<cluster-name> Defines the cluster you want to create the record in.
  • <field-names> Defines the fields you want to add the records to, in a comma-separated list.
  • <field-values> Defines the values you want to insert, in a comma-separated list.

Examples

  • Insert a new record into the class Profile, using the name Jay and surname Miner:

```

  1. orientdb> INSERT INTO Profile (name, surname) VALUES ('Jay', Miner')

  2. Inserted record in 0,060000 sec(s). `` - Insert a new record into the classEmployee`, while defining a relationship:

```

  1. orientdb> INSERT INTO Employee (name, boss) VALUES ('Jack', 11:99) ``` - Insert a new record, adding a collection of relationships:

```

  1. orientdb> INSERT INTO Profile (name, friends) VALUES ('Luca', [10:3, 10:4]) ```

For more information on other commands, see SQL and Console commands.