跳至主要內容
翻譯頁面

本頁面由英文在 AI 協助下翻譯而成。若兩者有出入,請以英文版本為準。

關鍵字

關鍵字是在 StackQL 文法中具有特殊意義的保留字。關鍵字可以使用任何大小寫輸入(大寫、小寫或大小寫混合),依照慣例,所有範例中的關鍵字都以大寫表示。將關鍵字當作識別碼使用時(例如作為資料行別名),必須以雙引號括住,如 SELECT name AS "group"。StackQL 中的關鍵字包括:

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