Skip to content

Latest commit

 

History

History
45 lines (32 loc) · 2 KB

Console-Command-Display-Raw-Record.md

File metadata and controls

45 lines (32 loc) · 2 KB
# Console - `DISPLAYS RAW RECORD` Displays details on the given record from the last returned result-set in a binary format. **Syntax** ```sql DISPLAY RAW RECORD ``` - **``** Defines the relative position of the record in the last result-set. **Example** - Query the database on the class `V` to generate a result-set: 
  orientdb {db=GratefulDeadConcerts}> SELECT song_type, name, performances FROM V LIMIT 6

  -----+-------+--------+----------+-------------------------+--------------
   #   | @RID  | @CLASS | song_type | name                   | performances
  -----+-------+--------+----------+-------------------------+--------------
   0   | #9:1  | V      | cover     | HEY BO DIDDLEY         | 5                 
   1   | #9:2  | V      | cover     | IM A MAN               | 1                 
   2   | #9:3  | V      | cover     | NOT FADE AWAY          | 531               
   3   | #9:4  | V      | original  | BERTHA                 | 394               
   4   | #9:5  | V      | cover     | GOING DOWN THE ROAD... | 293               
   5   | #9:6  | V      | cover     | MONA                   | 1                
   6   | #9:7  | V      | null      | Bo_Diddley             | null       
  -----+-------+--------+-----------+------------------------+-------------
  LIMIT EXCEEDED: resultset contains more items not displayed (limit=6)
  6 item(s) found. Query executed in 0.136 sec(s).
- Display raw record on the song "Hey Bo Diddley" from the result-set: 
  orientdb {db=GratefulDeadConcerts}> DISPLAY RAW RECORD 0

  Raw record content. The size is 292 bytes, while settings force to print first 150 bytes:
  �V�song_type���name���type���performances���out_followed_by���out_written_by���out_sung_by���in_followed_by��cover�HEY BO D
>For more information on other commands available, see [Console Commands](Console-Commands.md).