휘발성 테이블의 추출
데이터 조회
데이터 조회는 다른 테이블 유형과 마찬가지로, 아래와 같이 수행할 수 있다.
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.최근 업데이트