簡介
本節很重要,請大家收藏,避免在編寫程序的時候踩坑。因為關鍵字是被 TDengine 系統使用的,如果你在 SQL 中使用了保留關鍵詞,并且沒有被反引號包括時,會報語法錯誤,當你不知道這個是保留關鍵詞時,就會反復檢測語法,最后發現語法也沒問題,而是保留關鍵詞的問題,了解了這章內容,你就不會再踩這些坑了。
保留關鍵字
目前 TDengine 有 200 多個內部保留關鍵字,這些關鍵字如果需要用作庫名、表名、超級表名、子表名、數據列名及標簽列名等,無論大小寫,需要使用符號 `
將關鍵字括起來使用,例如 `ADD`。
關鍵字列表如下:
A
關鍵字 說明 ABORT ACCOUNT ACCOUNTS ADD AFTER AGGREGATE ALIAS ALIVE ALL ALTER ANALYZE 3.3.4.3+ AND ANODE 3.3.4.3+ ANODES 3.3.4.3+ ANOMALY_WINDOW 3.3.4.3+ ANTI APPS ARBGROUPS ARROW AS ASC ASOF ASYNC 3.3.6.0+ AT_ONCE ATTACH AUTO 3.3.5.0+ ASSIGN 3.3.6.0+
B
關鍵字 說明 BALANCE BEFORE BEGIN BETWEEN BIGINT BIN BINARY BITAND BITAND BITNOT BITOR BLOB BLOCKS BNODE BNODES BOOL BOTH BUFFER BUFSIZE BWLIMIT BY
C
關鍵字 說明 CACHE CACHEMODEL CACHESIZE CASE CAST CHANGE CHILD CLIENT_VERSION CLUSTER COLON COLS 3.3.6.0+ COLUMN COMMA COMMENT COMP COMPACT COMPACTS COMPACT_INTERVAL 3.3.5.0+ COMPACT_TIME_OFFSET 3.3.5.0+ COMPACT_TIME_RANGE 3.3.5.0+ CONCAT CONFLICT CONNECTION CONNECTIONS CONNS CONSUMER CONSUMERS CONTAINS CONTINUOUS_WINDOW_CLOSE 3.3.6.0+ COPY COUNT COUNT_WINDOW CREATE CREATEDB CURRENT_USER
D
關鍵字 說明 DATABASE DATABASES DBS DECIMAL 3.3.6.0+ DEFERRED DELETE DELETE_MARK DELIMITERS DESC DESCRIBE DETACH DISK_INFO 3.3.5.0+ DISTINCT DISTRIBUTED DIVIDE DNODE DNODES DOT DOUBLE DROP DURATION
E
關鍵字 說明 EACH ELSE ENABLE ENCRYPT_ALGORITHM ENCRYPT_KEY ENCRYPTIONS END EQ EVENT_WINDOW EVERY EXCEPT EXISTS EXPIRED EXPLAIN
F
關鍵字 說明 FAIL FHIGH 3.3.4.3+ FILE FILL FILL_HISTORY FIRST FLOAT FLOW 3.3.4.3+ FLUSH FOR FORCE FORCE_WINDOW_CLOSE 3.3.4.3+ FROM FROWTS 3.3.4.3+ FULL FUNCTION FUNCTIONS
G
關鍵字 說明 GE GEOMETRY GLOB GRANT GRANTS GROUP GT
H
I
關鍵字 說明 ID IF IGNORE ILLEGAL IMMEDIATE IMPORT IN INDEX INDEXES INITIALLY INNER INSERT INSTEAD INT INTEGER INTERSECT INTERVAL INTO IPTOKEN IROWTS IROWTS_ORIGIN 3.3.5.0+ IS IS_IMPORT ISFILLED ISNULL
J
K
關鍵字 說明 KEEP KEEP_TIME_OFFSET KEY KILL
L
關鍵字 說明 LANGUAGE LAST LAST_ROW LE LEADER LEADING LEFT LEVEL 3.3.0.0 - 3.3.2.11 LICENCES LIKE LIMIT LINEAR LOCAL LOGS LP LSHIFT LT
M
關鍵字 說明 MACHINES MATCH MAX_DELAY MAXROWS MEDIUMBLOB MERGE META META_ONLY 3.3.6.0+ MINROWS MINUS MNODE MNODES MODIFY MODULES
N
關鍵字 說明 NCHAR NE NEXT NMATCH NONE NORMAL NOT NOTIFY 3.3.6.0+ NOTIFY_HISTORY 3.3.6.0+ NOTNULL NOW NULL NULL_F NULLS
O
關鍵字 說明 OF OFFSET ON ONLY ON_FAILURE 3.3.6.0+ OR ORDER OUTER OUTPUTTYPE
P
關鍵字 說明 PAGES PAGESIZE PARTITION PASS PAUSE PI PLUS PORT POSITION PPS PRECISION PREV PRIMARY PRIVILEGE PRIVILEGES
Q
關鍵字 說明 QDURATION QEND QNODE QNODES QSTART QTAGS QTIME QUERIES QUERY QUESTION
R
關鍵字 說明 RAISE RAND RANGE RATIO READ RECURSIVE REGEXP 3.3.6.0+ REDISTRIBUTE REM REPLACE REPLICA RESET RESTORE RESTRICT RESUME RETENTIONS REVOKE RIGHT ROLLUP ROW ROWTS RP RSHIFT
S
關鍵字 說明 S3_CHUNKPAGES S3_COMPACT S3_KEEPLOCAL SCHEMALESS SCORES SELECT SEMI SERVER_STATUS SERVER_VERSION SESSION SET SHOW SINGLE_STABLE SLASH SLIDING SLIMIT SMA SMALLINT SMIGRATE SNODE SNODES SOFFSET SPLIT STABLE STABLES STAR START STATE STATE_WINDOW STATEMENT STORAGE STREAM STREAMS STRICT STRING STT_TRIGGER SUBSCRIBE SUBSCRIPTIONS SUBSTR SUBSTRING SUBTABLE SYSINFO SYSTEM
T
關鍵字 說明 TABLE TABLE_PREFIX TABLE_SUFFIX TABLES TAG TAGS TBNAME THEN TIMES TIMESTAMP TIMEZONE TINYINT TO TODAY TOPIC TOPICS TRAILING TRANSACTION TRANSACTIONS TRIGGER TRIM TRUE_FOR 3.3.6.0+ TSDB_PAGESIZE TSERIES TSMA TSMAS TTL
U
關鍵字 說明 UNION UNSAFE UNSIGNED UNTREATED UPDATE USE USER USERS USING
V
關鍵字 說明 VALUE VALUE_F VALUES VARBINARY VARCHAR VARIABLE VARIABLES VERBOSE VGROUP VGROUPS VIEW VIEWS VNODE VNODES
W
關鍵字 說明 WAL WAL_FSYNC_PERIOD WAL_LEVEL WAL_RETENTION_PERIOD WAL_RETENTION_SIZE WAL_ROLL_PERIOD WAL_SEGMENT_SIZE WATERMARK WDURATION WEND WHEN WHERE WINDOW WINDOW_CLOSE WINDOW_OFFSET WITH WRITE WSTART
_
_C0 _IROWTS _QDURATION _QEND _QSTART _ROWTS _WDURATION _WEND _WSTART
訪問官網
更多內容歡迎訪問 TDengine 官網