Skip to main content

Keywords

Keywords are reserved words that have significance in the StackQL grammar. Keywords can be entered in any case (upper, lower or mixed), they are capitalized in all of the examples by convention. A keyword used as an identifier, for example as a column alias, must be enclosed in double quotes, as in SELECT name AS "group". Keywords in StackQL include:

ADD, AND, AS, ASC, BETWEEN, BINARY, BY, CASE, COLLATE, CONVERT, CREATE, CROSS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DATABASE, DATABASES, DELETE, DESC, DESCRIBE, DISTINCT, DIV, DROP, ELSE, END, ESCAPE, EXEC, EXISTS, EXPLAIN, FALSE, FOR, FROM, GROUP, HAVING, IF, IGNORE, IN, INDEX, INNER, INSERT, INTERVAL, INTO, IS, JOIN, LEFT, LIKE, LIMIT, LOCALTIME, LOCALTIMESTAMP, LOCK, MOD, NATURAL, NEXT, NOT, NULL, OFF, ON, OR, ORDER, OUTER, OVER, RECURSIVE, REGEXP, REPLACE, RETURNING, RIGHT, SCHEMA, SELECT, SEPARATOR, SESSION, SET, SHOW, SUBSTR, SUBSTRING, TABLE, THEN, TIMESTAMPADD, TIMESTAMPDIFF, TO, TRUE, UNION, UNSET, UPDATE, USE, USING, UTC_DATE, UTC_TIME, UTC_TIMESTAMP, VALUES, WHEN, WHERE, XOR