Getting Started

Documentation

Glish

Learn More

Programming

Contact Us

Version 1.9 Build 2065

News	FAQ
Search	Home

Command summary

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 [AS type] | 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.