Orientdb 简明教程

OrientDB - Reload Record

Reload Record 与加载记录命令类似,也用于从架构中加载特定记录。加载记录会借助记录 ID 加载记录。它在结果集中用 @rid 符号表示。主要区别在于重新加载记录会忽略缓存,当应用外部并发事务更改记录时,这非常有用。它会提供最新更新。

Reload Record also works similar to Load Record command and is also 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 result-set. The main difference is Reload record ignores the cache which is useful when external concurrent transactions is applied to change the record. It will give the latest update.

以下语句是重新加载记录命令的基本语法。

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

RELOAD RECORD <record-id>

其中 <record-id> 定义您要重新加载的记录的记录 ID。

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

如果您不知道特定记录的记录 ID,则可以在表上执行任何查询。在结果集中,您会找到相应记录的记录 ID (@rid)。

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 the previous chapter.

Sr.No.

Name

Age

1

Satish

25

2

Krishna

26

3

Kiran

29

4

Javeed

21

5

Raja

29

尝试以下查询以检索具有记录 ID @rid: #11:0 的记录。

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