Machbase DBMS
Feature and Tables
Log Table
Log Data Input
Insert

Insert

Similar to other commercial RDBMSs, you can first create the table and enter the data using the INSERT INTO statement.

Machbase provides the ‘machsql’ tool as an interactive query processor.

Create Table 

CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... );
CREATE TABLE sensor_data ( id VARCHAR(32), val DOUBLE );

Data Insertion 

INSERT INTO table_name VALUES (value1, value2, value3, ...);
INSERT INTO sensor_data VALUES('sensor1', 10.1); INSERT INTO sensor_data VALUES('sensor2', 20.2); INSERT INTO sensor_data VALUES('sensor3', 30.3);

Confirm Data Insertion 

SELECT column1, column2, ... FROM table_name;
SELECT * FROM sensor_data;

Entire Process

Below is an example using machsql.

Mach> CREATE TABLE sensor_data (id VARCHAR(32), val DOUBLE);
 Created successfully.
Mach> INSERT INTO sensor_data VALUES('sensor1', 10.1);
 1 row(s) inserted.
Mach> INSERT INTO sensor_data VALUES('sensor2', 20.2);
 1 row(s) inserted.
Mach> INSERT INTO sensor_data VALUES('sensor3', 30.3);
 1 row(s) inserted.
Mach> SELECT * FROM sensor_data;
ID VAL
-----------------------------------------------------------------
sensor3 30.3
sensor2 20.2
sensor1 10.1
[3] row(s) selected.
Last updated on
Append