Version 1.9 Build 1556

News	FAQ
Search	Home

Next: Selection from a table Up: NOTE 199 - Table Query Language Previous: Introduction

TaQL Commands

TaQL contains six commands. In the commands shown below the square brackets are not part of the syntax, but indicate the optional parts of the commands.

selection

  SELECT [[DISTINCT] column_list] [INTO table [AS type]]
    FROM table_list [WHERE expression]
    [ORDERBY [DISTINCT] sort_list]
    [LIMIT expression] [OFFSET expression] [GIVING table|set]

It can be used to get an optionally sorted subset from a table.

updating

  UPDATE table_list SET update_list [FROM table_list]
    [WHERE ...] [ORDERBY ...] [LIMIT ...] [OFFSET ...]

It can be used to update data in (a subset of) the first table in the table list.

addition

  INSERT INTO table_list [(column_list)] VALUES (expr_list)
or
  INSERT INTO table_list [(column_list)] SELECT_command

It can be used to add and fill new rows in the first table in the table list.

deletion
```
  DELETE FROM table_list
    [WHERE ...] [ORDERBY ...] [LIMIT ...] [OFFSET ...]
```
It can be used to delete some or all rows from the first table in the table list.
calculation
```
  CALC [FROM table_list CALC] expression
```
It can be used to calculate an expression, in which columns in a table can be used.
table creation
```
  CREATE TABLE table [column_spec] [DMINFO datamanager_list]
```
It can be used to create a new table with the given columns. in a table can be used.

The commands and verbs in the commands are case-insensitive, but case is important in string values and in names of columns and keywords. Whitespace (blanks and tabs) can be used at will.
A later section (Modifying a table) explains the UPDATE, INSERT, and DELETE command in more detail. The CREATE TABLE is explained in section (Creating a table).
Another section (Calculations on a table) explains the CALC command in more detail.

Next: Selection from a table Up: NOTE 199 - Table Query Language Previous: Introduction Contents