Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 3 Current »

데이터 조회

데이터 조회는 다른 테이블 유형과 마찬가지로, 아래와 같이 수행할 수 있다.

iFlux> create volatile table vtable (id integer primary key, name varchar(20));
Created successfully.
iFlux> insert into vtable values(1, 'west device');
1 row(s) inserted.
iFlux> insert into vtable values(2, 'east device');
1 row(s) inserted.
iFlux> insert into vtable values(3, 'north device');
1 row(s) inserted.
iFlux> insert into vtable values(4, 'south device');
1 row(s) inserted.
iFlux> select * from vtable;
ID          NAME                  
-------------------------------------
1           west device           
2           east device           
3           north device          
4           south device          
[4] row(s) selected.
iFlux> select * from vtable where id = 1;
ID          NAME                  
-------------------------------------
1           west device           
[1] row(s) selected.
iFlux> select * from vtable where name like 'west%';
ID          NAME                  
-------------------------------------
1           west device           
[1] row(s) selected.



  • No labels