Orientdb 简明教程

OrientDB - Export Record

Export Record 是用于将加载的记录导出到请求和支持的格式的命令。如果您执行任何错误的语法，它都会提供支持的格式列表。OrientDB 是一系列文档数据库，因此 JSON 是默认支持的格式。

Export Record is the command used to export the loaded record into the requested and supported format. If you are executing any wrong syntax, it will give the list of supported formats. OrientDB is a family of Document database, therefore JSON is the default supported format.

以下语句是导出记录命令的基本语法。

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

EXPORT RECORD <format>

其中 <Format> 定义您要获取记录的格式。

Where <Format> defines the format you want to get the record.

Note - 导出命令将根据记录 ID 导出加载的记录。

Note − Export command will export the loaded record based on Record ID.

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

使用以下查询以 JSON 格式导出加载的记录 (#11:0)。

Use the following query to export he loaded record (#11:0) into JSON format.

orientdb {db = demo}> EXPORT RECORD json

如果成功执行了以上查询，您会获得以下输出。

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

{
   "@type": "d",
      "@rid": "#11:0",
   "@version": 1,
   "@class": "Customer",
      "id": 1,
      "name": "satish",
      "age": 25
}