Console Command Select

Console command: select

Select

Execute the query against the database using the SQL language.

Syntax

select <conditions>

Example

> select from person

---+--------+--------------------+--------------------+--------------------+--------------------+--------------------
  #| REC ID |PARENT              |CHILDREN            |NAME                |SURNAME             |CITY
---+--------+--------------------+--------------------+--------------------+--------------------+--------------------
  0|     5:0|null                |null                |Giuseppe            |Garibaldi           |-6:0
  1|     5:1|5:0                 |null                |Napoleone           |Bonaparte           |-6:0
  2|     5:2|5:3                 |null                |Nicholas            |Churcill            |-6:1
  3|     5:3|5:2                 |null                |Winston             |Churcill            |-6:1
  4|     5:4|null                |[2]                 |Barack              |Obama               |-6:2
  5|     5:5|5:4                 |null                |Malia Ann           |Obama               |null
  6|     5:6|5:4                 |null                |Natasha             |Obama               |null
---+--------+--------------------+--------------------+--------------------+--------------------+--------------------
7 item(s) found. Query executed in 0.025 sec(s).

To know more about the SQL syntax used in Orient take a look to: SQL-Query.

This is a command of the Orient console. To know all the commands go to Console-Commands.