Content Comparison

LikeotherconventionalRDBMS,youneedtocreateatablefirstandenterthe datausingINSERTINTOstatement.Machbaseprovides'machsql'asan interactivetool.

Create table

Syntax:

Code Block

language	sql

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

...

Code Block

language	sql

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

Syntax:

Code Block

language	sql

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

...

Code Block

language	sql

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

Syntax:

Code Block

language	sql

SELECT	column1,	column2,	... 
FROM	table_name;

...