LikeotherconventionalRDBMS,youneedtocreateatablefirstandenterthe datausingINSERTINTOstatement.Machbaseprovides'machsql'asan interactivetool다른 상용 RDBMS와 유사하게, 테이블을 먼저 생성하고 데이터는 INSERT INTO문을 이용하여 데이터를 입력할 수 있다. 마크베이스는 'machsql'도구를 대화형 질의 처리기로 제공한다.
Create table
Syntax:
| Code Block | ||
|---|---|---|
| ||
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
); |
...
| Code Block | ||
|---|---|---|
| ||
SELECT * FROM sensor_data; |
'machsql' is run as followsmachsql을 사용한 예제이다.
| Code Block |
|---|
[mach@localhost ~]$ machsql
=================================================================
Machbase Client Query Utility
Release Version 3.5.0.826b8f2.official
Copyright 2014, Machbase Inc. or its subsidiaries.
All Rights Reserved.
=================================================================
Machbase server address (Default:127.0.0.1) :
Machbase user ID (Default:SYS)
Machbase User Password :
MACH_CONNECT_MODE=INET, PORT=5656
mach> CREATE TABLE sensor_data
(
id VARCHAR(32),
val DOUBLE
);
Created successfully.
Elapsed time: 0.162
mach> INSERT INTO sensor_data VALUES('sensor1', 10.1);
1 row(s) inserted.
Elapsed time: 0.000
mach> INSERT INTO sensor_data VALUES('sensor2', 20.2);
1 row(s) inserted.
Elapsed time: 0.000
mach> INSERT INTO sensor_data VALUES('sensor3', 30.3);
1 row(s) inserted.
Elapsed time: 0.000
mach> SELECT * FROM sensor_data;
ID VAL
-----------------------------------------------------------------
sensor3 30.3
sensor2 20.2
sensor1 10.1
[3] row(s) selected.
Elapsed time: 0.000 |
...