Load Record is used to load a particular record from the schema. Load record will load the record with the help of Record ID. It is represented with @rid symbol in the resultset.

The following statement is the basic syntax of the LOAD Record command.

LOAD RECORD <record-id>

Where <record-id> defines the record id of the record you want to load.

If you don’t know the Record ID of a particular record, then you can execute any query against the table. In the result-set you will find the Record ID (@rid) of the respective record.

Example

Let us consider the same Customer table that we have used in previous chapters.

Try the following query to retrieve the record having Record ID @rid: #11:0.

orientdb {db = demo}> LOAD RECORD #11:0

If the above query is executed successfully, you will get the following output.

+---------------------------------------------------------------------------+
| Document - @class: Customer        @rid: #11:0           @version: 1      |
+---------------------------------------------------------------------------+
|                     Name | Value                                          |
+---------------------------------------------------------------------------+
|                       id | 1                                              |
|                     name | satish                                         |
|                      age | 25                                             |
+---------------------------------------------------------------------------+