SQL

SQL

Hyprcubd’s query interface is done using a “SQL-like” language. The following statements are supported.

Statement Usage
SELECT Select specific rows and columns from a table
INSERT Insert rows into a table

Reserved Words

The following words are reserved and cannot be used where an identity is required (e.g. table names, column names).

  • SELECT
  • FROM
  • INSERT
  • CREATE
  • TABLES
  • TABLE
  • DATABASES
  • DATABASE
  • WHERE
  • INTO
  • VALUES
  • NULL
  • TRUE
  • FALSE
  • AND
  • OR
  • NOT
  • SHOW
  • AS
  • GROUP
  • BY
  • ORDER
  • TIMESERIES
  • LIMIT

Uppercase

Uppercase keywords are not required. select time from table is a valid query.