Versions Compared

Version Old Version 2 New Version 3
Changes made by

Grey Shim

Grey Shim

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
CREATE	 TABLE	 table_name	 (
				column1	datatype,
				column2	datatype,
				column3	datatype,
			
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
);

Example:

Code Block
languagesql
CREATE	 TABLE	 sensor_data	 
(
	 id	 VARCHAR(32),
 	val	 DOUBLE
);

Insert data

Syntax:

Code Block
languagesql
INSERT	 INTO	 table_name
VALUES	 (value1,	 value2,	 value3,	 ...);

Example:

Code Block
languagesql
INSERT	 INTO	 sensor_data	 VALUES('sensor1',	 10.1);
INSERT	 INTO	 sensor_data	 VALUES('sensor2',	 20.2);
INSERT INSERT	INTO	 sensor_data	 VALUES('sensor3',	 30.3);

Check inserted data

...

Code Block
languagesql
SELECT	 column1,	 column2,	 ...
FROM FROM	table_name;

Example:

Code Block
languagesql
SELECT	*	FROM	sensor_data;

...

Code Block
[mach@localhost	 ~]$	 machsql
=================================================================
					Machbase	Client	Query	Utility
					Release	Version	
     Machbase Client Query Utility
     Release Version 3.5.0.826b8f2.official
					Copyright	2014,	Machbase	Inc.	or	its	subsidiaries.
					All	Rights	Reserved. 

     Copyright 2014, Machbase Inc. or its subsidiaries.
     All Rights Reserved.
=================================================================
Machbase Machbase	server	 address	 (Default:127.0.0.1)	 :
Machbase Machbase	user	 ID		  (Default:SYS)
Machbase Machbase	User	 Password	 : 
MACH_CONNECT_MODE=INET,	 PORT=5656
mach> mach>	CREATE	 TABLE	 sensor_data
		(
			id			
     (
       id    VARCHAR(32),
			val			DOUBLE
		       val   DOUBLE
     );
Created Created	successfully.
Elapsed	 time:	 0.162
mach> mach>	INSERT	 INTO	 sensor_data	 VALUES('sensor1',	 10.1);
1 1	row(s)	 inserted.
Elapsed	 time:	 0.000
mach> mach>	INSERT	 INTO	 sensor_data	 VALUES('sensor2',	 20.2);
1	 row(s)	 inserted.
Elapsed	 time:	 0.000
mach> mach>	INSERT	 INTO	 sensor_data	 VALUES('sensor3',	 30.3);
1	 row(s)	 inserted.
Elapsed	 time:	 0.000
mach> mach>	SELECT	 *	 FROM	 sensor_data;
 ID			VAL

ID                                VAL
-----------------------------------------------------------------
sensor3			30.3 
sensor2			20.2
sensor1			10.1 
[3]	row(s)	selected. Elapsed	time:	                           30.3
sensor2                           20.2
sensor1                           10.1
[3] row(s) selected.
Elapsed time: 0.000