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.  
    3. Inserted record in 0,060000 sec(s).
  • Insert a new record into the class Employee, 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.