数据库关键字整理之——TiDB数据库

淩亂°似流年 2024-03-16 10:56 106阅读 0赞

关键字是指在数据库中有意义的字，通常是数据库内部使用， 不能用于命名用户的数据对象。 有的数据库还会详细划分，例如分为关键字，候选字，甚至更详细的分类。分类的标准例如有的是绝对不可以使用，有的通过一定手段例如添加双引号可以使用。

我们为了方便统一称之为关键字，通常用户编写的对象中使用关键字会造成错误或不确定的影响，为了避免这个问题，用户应该避免使用数据库的关键字(含保留字或其他保留别名等)。

这个系列主要整理了各大数据库的关键字，可以用于建库，建表，写存储过程，函数等场景避免冲突。最后会有个脚本工具用来检查是否使用关键字。  
  
9de7bb31d0644e7393039222babfed10

欢迎收藏。

## TiDB ##

ACCOUNT ACTION ADD ADMIN ADVISE AFTER AGAINST AGO ALGORITHM ALL ALTER ALWAYS ANALYZE AND ANY AS ASC ASCII AUTO\_ID\_CACHE AUTO\_INCREMENT AUTO\_RANDOM AUTO\_RANDOM\_BASE AVG AVG\_ROW\_LENGTH

BACKEND BACKUP BACKUPS BEGIN BETWEEN BIGINT BINARY BINDING BINDINGS BINLOG BIT BLOB BLOCK BOOL BOOLEAN BOTH BTREE BUCKETS BUILTINS BY BYTE

CACHE CANCEL CAPTURE CASCADE CASCADED CASE CHAIN CHANGE CHAR CHARACTER CHARSET CHECK CHECKPOINT CHECKSUM CIPHER CLEANUP CLIENT CMSKETCH COALESCE COLLATE COLLATION COLUMN COLUMNS COLUMN\_FORMAT COMMENT COMMIT COMMITTED COMPACT COMPRESSED COMPRESSION CONCURRENCY CONFIG CONNECTION CONSISTENT CONSTRAINT CONTEXT CONVERT CPU CREATE CROSS CSV\_BACKSLASH\_ESCAPE CSV\_DELIMITER CSV\_HEADER CSV\_NOT\_NULL CSV\_NULL CSV\_SEPARATOR CSV\_TRIM\_LAST\_SEPARATORS CUME\_DIST CURRENT CURRENT\_DATE CURRENT\_ROLE CURRENT\_TIME CURRENT\_TIMESTAMP CURRENT\_USER CYCLE

DATA DATABASE DATABASES DATE DATETIME DAY DAY\_HOUR DAY\_MICROSECOND DAY\_MINUTE DAY\_SECOND DDL DEALLOCATE DECIMAL DEFAULT DEFINER DELAYED DELAY\_KEY\_WRITE DELETE DENSE\_RANK DEPTH DESC DESCRIBE DIRECTORY DISABLE DISCARD DISK DISTINCT DISTINCTROW DIV DO DOUBLE DRAINER DROP DUAL DUPLICATE DYNAMIC

ELSE ENABLE ENCLOSED ENCRYPTION END ENFORCED ENGINE ENGINES ENUM ERROR ERRORS ESCAPE ESCAPED EVENT EVENTS EVOLVE EXCEPT EXCHANGE EXCLUSIVE EXECUTE EXISTS EXPANSION EXPIRE EXPLAIN EXTENDED

FALSE FAULTS FIELDS FILE FIRST FIRST\_VALUE FIXED FLOAT FLUSH FOLLOWING FOR FORCE FOREIGN FORMAT FROM FULL FULLTEXT FUNCTION

GENERAL GENERATED GLOBAL GRANT GRANTS GROUP GROUPS

HASH HAVING HIGH\_PRIORITY HISTORY HOSTS HOUR HOUR\_MICROSECOND HOUR\_MINUTE HOUR\_SECOND

IDENTIFIED IF IGNORE IMPORT IMPORTS IN INCREMENT INCREMENTAL INDEX INDEXES INFILE INNER INSERT INSERT\_METHOD INSTANCE INT INT1 INT2 INT3 INT4 INT8 INTEGER INTERVAL INTO INVISIBLE INVOKER IO IPC IS ISOLATION ISSUER

JOB JOBS JOIN JSON

KEY KEYS KEY\_BLOCK\_SIZE KILL

LABELS LAG LANGUAGE LAST LASTVAL LAST\_BACKUP LAST\_VALUE LEAD LEADING LEFT LESS LEVEL LIKE LIMIT LINEAR LINES LIST LOAD LOCAL LOCALTIME LOCALTIMESTAMP LOCATION LOCK LOGS LONG LONGBLOB LONGTEXT LOW\_PRIORITY

MASTER MATCH MAXVALUE MAX\_CONNECTIONS\_PER\_HOUR MAX\_IDXNUM MAX\_MINUTES MAX\_QUERIES\_PER\_HOUR MAX\_ROWS MAX\_UPDATES\_PER\_HOUR MAX\_USER\_CONNECTIONS MB MEDIUMBLOB MEDIUMINT MEDIUMTEXT MEMORY MERGE MICROSECOND MINUTE MINUTE\_MICROSECOND MINUTE\_SECOND MINVALUE MIN\_ROWS MOD MODE MODIFY MONTH

NAMES NATIONAL NATURAL NCHAR NEVER NEXT NEXTVAL NO NOCACHE NOCYCLE NODEGROUP NODE\_ID NODE\_STATE NOMAXVALUE NOMINVALUE NONE NOT NOWAIT NO\_WRITE\_TO\_BINLOG NTH\_VALUE NTILE NULL NULLS NUMERIC NVARCHAR

OFFSET ON ONLINE ONLY ON\_DUPLICATE OPEN OPTIMISTIC OPTIMIZE OPTION OPTIONALLY OR ORDER OUTER OUTFILE OVER

PACK\_KEYS PAGE PARSER PARTIAL PARTITION PARTITIONING PARTITIONS PASSWORD PERCENT\_RANK PER\_DB PER\_TABLE PESSIMISTIC PLUGINS PRECEDING PRECISION PREPARE PRE\_SPLIT\_REGIONS PRIMARY PRIVILEGES PROCEDURE PROCESS PROCESSLIST PROFILE PROFILES PUMP

QUARTER QUERIES QUERY QUICK

RANGE RANK RATE\_LIMIT READ REAL REBUILD RECOVER REDUNDANT REFERENCES REGEXP REGION REGIONS RELEASE RELOAD REMOVE RENAME REORGANIZE REPAIR REPEAT REPEATABLE REPLACE REPLICA REPLICATION REQUIRE RESPECT RESTORE RESTORES RESTRICT REVERSE REVOKE RIGHT RLIKE ROLE ROLLBACK ROUTINE ROW ROWS ROW\_COUNT ROW\_FORMAT ROW\_NUMBER RTREE

SAMPLES SECOND SECONDARY\_ENGINE SECONDARY\_LOAD SECONDARY\_UNLOAD SECOND\_MICROSECOND SECURITY SELECT SEND\_CREDENTIALS\_TO\_TIKV SEPARATOR SEQUENCE SERIAL SERIALIZABLE SESSION SET SETVAL SHARD\_ROW\_ID\_BITS SHARE SHARED SHOW SHUTDOWN SIGNED SIMPLE SKIP\_SCHEMA\_FILES SLAVE SLOW SMALLINT SNAPSHOT SOME SOURCE SPATIAL SPLIT SQL SQL\_BIG\_RESULT SQL\_BUFFER\_RESULT SQL\_CACHE SQL\_CALC\_FOUND\_ROWS SQL\_NO\_CACHE SQL\_SMALL\_RESULT SQL\_TSI\_DAY SQL\_TSI\_HOUR SQL\_TSI\_MINUTE SQL\_TSI\_MONTH SQL\_TSI\_QUARTER SQL\_TSI\_SECOND SQL\_TSI\_WEEK SQL\_TSI\_YEAR SSL START STARTING STATS STATS\_AUTO\_RECALC STATS\_BUCKETS STATS\_HEALTHY STATS\_HISTOGRAMS STATS\_META STATS\_PERSISTENT STATS\_SAMPLE\_PAGES STATUS STORAGE STORED STRAIGHT\_JOIN STRICT\_FORMAT SUBJECT SUBPARTITION SUBPARTITIONS SUPER SWAPS SWITCHES SYSTEM\_TIME

TABLE TABLES TABLESPACE TABLE\_CHECKSUM TEMPORARY TEMPTABLE TERMINATED TEXT THAN THEN TIDB TIFLASH TIKV\_IMPORTER TIME TIMESTAMP TINYBLOB TINYINT TINYTEXT TO TOPN TRACE TRADITIONAL TRAILING TRANSACTION TRIGGER TRIGGERS TRUE TRUNCATE TYPE

UNBOUNDED UNCOMMITTED UNDEFINED UNICODE UNION UNIQUE UNKNOWN UNLOCK UNSIGNED UPDATE USAGE USE USER USING UTC\_DATE UTC\_TIME UTC\_TIMESTAMP

VALIDATION VALUE VALUES VARBINARY VARCHAR VARCHARACTER VARIABLES VARYING VIEW VIRTUAL VISIBLE

WARNINGS WEEK WEIGHT\_STRING WHEN WHERE WIDTH WINDOW WITH WITHOUT WRITE

X509 XOR

YEAR YEAR\_MONTH

ZEROFILL