데이터 조회
데이터 조회는 다른 테이블 유형과 마찬가지로, 아래와 같이 수행할 수 있다.
...
| Code Block | ||
|---|---|---|
| ||
Mach> create volatile table vtable (id integer primary key, name varchar(20)); Created successfully. |
...
Mach> insert into vtable values(1, 'west device'); 1 row(s) inserted. |
...
Mach> insert into vtable values(2, 'east device'); 1 row(s) inserted. |
...
Mach> insert into vtable values(3, 'north device'); 1 row(s) inserted. |
...
Mach> insert into vtable values(4, 'south device'); 1 row(s) inserted. |
...
Mach> select * from vtable; ID NAME ------------------------------------- 1 west device 2 east device 3 north device 4 south device [4] row(s) selected. |
...
Mach> select * from vtable where id = 1; ID NAME ------------------------------------- 1 west device [1] row(s) selected. |
...
Mach> select * from vtable where name like 'west%'; ID NAME ------------------------------------- 1 west device [1] row(s) selected. |