7. Insert¶

7.1. Synopsis¶

INSERT INTO <table_name> (
$timestamp, <column_name> [, ... ] ) VALUES ( { <value> | <expression> } [, ... ] ) [, ...]  7.2. Description¶ INSERT INTO will insert a row into an existing table. It requires the timestamp to be explicitly provided using the special column $timestamp, which should always be the first column.

Column names are matched with their values using their index. The amount of columns should always be exactly equal to the amount of values.

QuasarDB being a column-oriented database supports inserting into a subset of the columns available for a certain table. The missing values will have a NULL-value and do not incur any storage costs.

7.3. Parameters¶

table_name

The name of the table to be created. Can be alphanumeric, but is not allowed to start with a number.

column_name

The name of the column to insert the data to.

value

The value to insert into the resprective column. The format of the valuedata needs to match the type of the column, otherwise an error will be thrown.

expression

The result of an expression which evaluates to a value. A common use case is to use now as the value for $timestamp. For more information on valid values for $timestamp, please refer to the documentation for timestamps.

7.4. Examples¶

Insert a 64-bit integer:

INSERT INTO example ('$timestamp', my_int) VALUES (now, 1234)  Insert a floating point / double: INSERT INTO example ('$timestamp', my_double) VALUES (now, 12.34)


Insert a blob string:

INSERT INTO example ('$timestamp', my_blob) VALUES (now, 'etaoin shrdlu')  Insert a timestamp: INSERT INTO example ('$timestamp', my_ts) VALUES (now, 2018-08-01T03:00:00)


Insert a timestamp referring to a day:

INSERT INTO example ('$timestamp', my_ts) VALUES (now, 2018-01-01)  Insert a timestamp referring to a specific nanoesecond: INSERT INTO example ('$timestamp', my_ts) VALUES (now, 2018-08-01T00:00:00.000000001Z)


Insert a row with multiple columns:

INSERT INTO example ('$timestamp', my_int, my_double, my_blob, my_ts) VALUES (now, 1234, 12.34, 'etaoin shrdlu', 2018-08-01)  Insert three rows with one 64-bit integer each: INSERT INTO example ('$timestamp', my_int) VALUES (now, 1234), (now, 2345), (now, 3456)

6. Select
8. Function & Operators