TDSQL MySQL版 保留关键字

此文章将列出 TDSQL MySQL 版当前所涉及的保留关键字,在SQL中使用时需添加 ‘’ 才能被 Proxy 解析。

相关产品
TDSQL MySQL版 产品页,含版本规格、价格与购买入口。

主要保留关键字变更记录

关键字 变更内容 引入版本
CYCLE 允许 CYCLE 关键字做表名字段名 22.3.0
SEQUENCE 允许 SEQUENCE 关键字做表名字段名 22.3.0
TDSQL_SUBDISTRIBUTED proxy 多级分区表 22.3.0
WITHOUT proxy 回收站语法 22.3.0
RECYCLE_BIN proxy 回收站语法 22.3.0
RECYCLE_ID proxy 回收站语法 22.3.0
CLEAR proxy 回收站语法 22.3.0
TEMPLATE set 级全局索引 22.2.0
TDSQL_AUTOINCVAL 通过命令手动获取自增 id 22.1.4
MANUAL_SWITCH rebalance 手动切换路由 22.1.0
SWITCH rebalance 手动切换路由 22.1.0
SWITCH_DATETIME rebalance 手动切换路由 22.1.0
DDL 查询 ddl 任务相关信息 20.8
OFFLINE 离线 rebalance 19.1
REBALANCE_TASK 查询 rebalance 任务相关信息 19.1
TDSQL_RESETVAL sequence 重置序列号 17.2
TDSQL_DISTRIBUTED range/list 分区表 16.3
SKIP select for update 的 option 15.1
LOCKED select for update 的 option 15.1
NOWAIT select for update 的 option 15.1
OF select for update 的 option 15.1
CYCLE proxy 兼容 db 的 sequence 语法 15.1
INCREMENT proxy 兼容 db 的 sequence 语法 15.1
LASTVAL proxy 兼容 db 的 sequence 语法 15.1
MAXVALUE proxy 兼容 db 的 sequence 语法 15.1
NEXTVAL proxy 兼容 db 的 sequence 语法 15.1
NOCACHE proxy 兼容 db 的 sequence 语法 15.1
NOCYCLE proxy 兼容 db 的 sequence 语法 15.1
NOMAXVALUE proxy 兼容 db 的 sequence 语法 15.1
NOMINVALUE proxy 兼容 db 的 sequence 语法 15.1
PREVIOUS proxy 兼容 db 的 sequence 语法 15.1
RESTART proxy 兼容 db 的 sequence 语法 15.1
REUSE proxy兼容 db 的 sequence 语法 15.1
SEQUENCE proxy 兼容 db 的 sequence 语法 15.1
SETVAL proxy 兼容 db 的 sequence 语法 15.1
TDSQL_CYCLE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_INCREMENT proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_LASTVAL proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_MINVALUE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_NEXTVAL proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_NOCACHE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_NOCYCLE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_NOMAXVALUE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_NOMINVALUE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_PREVIOUS proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_RESTART prox y支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_REUSE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_SEQUENCE proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21
TDSQL_SETVAL proxy 支持带 tdsql_ 前缀的 sequence 语法 13.21

更早的保留关键字列表

&&, <, <=, <>, !=, =, >, >=, <<, >>, <=>, ACCESSIBLE, ACTION, ADD, ADMIN, AFTER, AGAINST, AGGREGATE, ALL, ALGORITHM, ALTER, ALWAYS, ANALYZE, AND, ANY, AS, ASC, ASCII, ASENSITIVE, AT, AUTHORS, AUTO_INCREMENT,AUTOEXTEND_SIZE, AUTO, AVG, AVG_ROW_LENGTH, BACKUP, BEFORE, BEGIN, BETWEEN, BIGINT, BINARY, BINLOG, BIT, BLOB, BLOCK, BODY, BOOL, BOOLEAN, BOTH, BTREE, BY, BYTE, CACHE, CALL, CASCADE, CASCADED, CASE,CATALOG_NAME, CHAIN, CHANGE, CHANGED, CHAR, CHARACTER, CHARSET, CHECK, CHECKPOINT, CHECKSUM, CIPHER, CLASS_ORIGIN, CLIENT, CLIENT_STATISTICS, CLOSE, COALESCE, CODE, COLLATE, COLLATION, COLUMN, COLUMN_NAME,COLUMNS, COLUMN_ADD, COLUMN_CHECK, COLUMN_CREATE, COLUMN_DELETE, COLUMN_GET, COMMENT, COMMIT, COMMITTED, COMPACT, COMPLETION, COMPRESSED, CONCURRENT, CONDITION, CONNECTION, CONSISTENT, CONSTRAINT, CONSTRAINT_CATALOG, CONSTRAINT_NAME, CONSTRAINT_SCHEMA, CONTAINS, CONTEXT, CONTINUE, CONTRIBUTORS, CONVERT, CPU, CREATE, CROSS, CUBE, CURRENT, CURRENT_DATE, CURRENT_POS, CURRENT_ROLE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR, CURSOR_NAME, CYCLE, DATA, DATABASE, DATABASES, DATAFILE, DATE, DATETIME, DAY, DAY_HOUR, DAY_MICROSECOND, DAY_MINUTE, DAY_SECOND, DEALLOCATE, DEC, DECIMAL, DECLARE, DEFAULT, DEFINER, DELAYED, DELAY_KEY_WRITE, DELETE, DESC, DESCRIBE, DES_KEY_FILE, DETERMINISTIC, DIAGNOSTICS, DIRECTORY, DISABLE, DISCARD, DISK, DISTINCT, DISTINCTROW, DIV, DO, DOUBLE, DROP, DUAL, DUMPFILE, DUPLICATE, DYNAMIC, EACH, ELSE, ELSEIF, ENABLE, ENCLOSED, END, ENDS, ENGINE, ENGINES, ENUM, ERROR, ERRORS, ESCAPE, ESCAPED, EVENT, EVENTS, EVERY, EXAMINED, EXCHANGE, EXECUTE, EXISTS, EXIT, EXPANSION, EXPORT, EXPLAIN, EXTENDED, EXTENT_SIZE, FALSE, FAST, FAULTS, FETCH, FIELDS, FILE, FIRST, FIXED, FLOAT, FLOAT4, FLOAT8, FLUSH, FOR, FORCE, FOREIGN, FOUND, FROM, FULL, FULLTEXT, FUNCTION, GENERAL, GENERATED, GEOMETRY, GEOMETRYCOLLECTION, GET_FORMAT, GET, GLOBAL, GRANT, GRANTS, GROUP, HANDLER, HARD, HASH, HAVING, HELP, HIGH_PRIORITY, HOST, HOSTS, HOUR, HOUR_MICROSECOND, HOUR_MINUTE, HOUR_SECOND, ID, IDENTIFIED, IF, IGNORE, IGNORE_SERVER_IDS, IMPORT, IN, INCREMENT, INDEX, INDEXES, INDEX_STATISTICS, INFILE, INITIAL_SIZE, INNER, INOUT, INSENSITIVE, INSERT, INSERT_METHOD, INSTALL, INT, INT1, INT2, INT3, INT4, INT8, INTEGER, INTERVAL, INTO, IO, IO_THREAD, IPC, IS, ISOLATION, ISSUER, ITERATE, INVOKER, JOIN, JSON, KEY, KEYS, KEY_BLOCK_SIZE, KILL, LANGUAGE, LAST, LAST_VALUE, LASTVAL, LEADING, LEAVE, LEAVES, LEFT, LESS, LEVEL, LIKE, LIMIT, LINEAR, LINES, LINESTRING, LIST, LOAD, LOCAL, LOCALTIME, LOCALTIMESTAMP, LOCK, LOCKS, LOGFILE, LOGS, LONG, LONGBLOB, LONGTEXT, LOOP, LOW_PRIORITY, MASTER, MASTER_CONNECT_RETRY,MASTER_GTID_POS, MASTER_HOST, MASTER_LOG_FILE, MASTER_LOG_POS, MASTER_PASSWORD, MASTER_PORT, MASTER_SERVER_ID, MASTER_SSL, MASTER_SSL_CA, MASTER_SSL_CAPATH, MASTER_SSL_CERT, MASTER_SSL_CIPHER,MASTER_SSL_CRL, MASTER_SSL_CRLPATH, MASTER_SSL_KEY, MASTER_SSL_VERIFY_SERVER_CERT, MASTER_USER, MASTER_USE_GTID, MASTER_HEARTBEAT_PERIOD, MATCH, MAX_CONNECTIONS_PER_HOUR, MAX_QUERIES_PER_HOUR, MAX_ROWS, MAX_SIZE, MAX_UPDATES_PER_HOUR, MAX_USER_CONNECTIONS, MAXVALUE, MEDIUM, MEDIUMBLOB, MEDIUMINT, MEDIUMTEXT, MEMORY, MERGE, MESSAGE_TEXT, MICROSECOND, MIDDLEINT, MIGRATE, MINUTE, MINUTE_MICROSECOND,MINUTE_SECOND, MINVALUE, MIN_ROWS, MOD, MODE, MODIFIES, MODIFY, MONTH, MULTILINESTRING, MULTIPOINT, MULTIPOLYGON, MUTEX, MYSQL_ERRNO, NAME, NAMES, NATIONAL, NATURAL, NDB, NDBCLUSTER, NCHAR, NEW, NEXT, NEXTVAL, NO, NOMAXVALUE, NOMINVALUE, NOCACHE, NOCYCLE, NO_WAIT, NODEGROUP, NONE, NOT, NO_WRITE_TO_BINLOG, NULL, NUMBER, NUMERIC, NVARCHAR, OFFSET, OLD_PASSWORD, ON, ONE, ONLINE, ONLY, OPEN, OPTIMIZE, OPTIONS, OPTION, OPTIONALLY, OR, ORDER, OUT, OUTER, OUTFILE, OWNER, PACK_KEYS, PAGE, PAGE_CHECKSUM, PARSER, PARSE_VCOL_EXPR, PARTIAL, PARTITION, PARTITIONING, PARTITIONS, PASSWORD, PERSISTENT, PHASE, PLUGIN,PLUGINS, POINT, POLYGON, PORT, PRECISION, PREPARE, PRESERVE, PREV, PREVIOUS, PRIMARY, PRIVILEGES, PROCEDURE, PROCESS, PROCESSLIST, PROFILE, PROFILES, PROXY, PURGE, QUARTER, QUERY, QUICK, RANGE, READ, READ_ONLY, READ_WRITE, READS, REAL, REBUILD, RECOVER, REDO_BUFFER_SIZE, REDOFILE, REDUNDANT, REFERENCES, REGEXP, RELAY, RELAYLOG, RELAY_LOG_FILE, RELAY_LOG_POS, RELAY_THREAD, RELEASE, RELOAD, REMOVE, RENAME, REORGANIZE, REPAIR, REPEATABLE, REPLACE, REPLICATION, REPEAT, REQUIRE, RESET, RESIGNAL, RESTART, RESTORE, RESTRICT, RESUME, RETURNED_SQLSTATE, RETURN, RETURNING, RETURNS, REUSE, REVERSE, REVOKE, RIGHT, RLIKE,ROLE, ROLLBACK, ROLLUP, ROUTINE, ROW, ROW_COUNT, ROWS, ROW_FORMAT, RTREE, SAVEPOINT, SCHEDULE, SCHEMA, SCHEMA_NAME, SCHEMAS, SECOND,SECOND_MICROSECOND,SECURITY, SELECT, SENSITIVE, SEPARATOR, SEQUENCE, SERIAL,SERIALIZABLE, SESSION, SERVER, SET, SETVAL, SHARDKEY, SHARE, SHOW, SHUTDOWN, SIGNAL, SIGNED, SIMPLE, SLAVE, SLAVES, SLAVE_POS, SLOW, SNAPSHOT, SMALLINT, SOCKET, SOFT, SOME, SONAME, SOUNDS, SOURCE, SPATIAL, SPECIFIC, SQL, SQLEXCEPTION, SQLSTATE, SQLWARNING, SQL_BIG_RESULT, SQL_BUFFER_RESULT, SQL_CACHE, SQL_CALC_FOUND_ROWS, SQL_NO_CACHE, SQL_SMALL_RESULT, SQL_THREAD, SQL_TSI_SECOND, SQL_TSI_MINUTE, SQL_TSI_HOUR,SQL_TSI_DAY, SQL_TSI_WEEK, SQL_TSI_MONTH, SQL_TSI_QUARTER, SQL_TSI_YEAR, SSL, START, STARTING, STARTS, STATS_AUTO_RECALC, STATS_PERSISTENT, STATS_SAMPLE_PAGES, STATUS, STOP, STORAGE, STORED, STRAIGHT_JOIN, STRING, SUBCLASS_ORIGIN, SUBJECT, SUBPARTITION, SUBPARTITIONS, SUPER, SUSPEND, SWAPS, SWITCHES, TABLE, TABLE_NAME, TABLES, TABLESPACE, TABLE_STATISTICS, TABLE_CHECKSUM, TEMPORARY, TEMPTABLE, TERMINATED, TEXT,THAN, THEN, TIME, TIMESTAMP, TIMESTAMPADD, TIMESTAMPDIFF, TINYBLOB, TINYINT, TINYTEXT, TO, TRAILING, TRANSACTION, TRANSACTIONAL, TRIGGER, TRIGGERS, TRUE, TRUNCATE, TYPE, TYPES, UNCOMMITTED, UNDEFINED, UNDO_BUFFER_SIZE, UNDOFILE, UNDO, UNICODE, UNION, UNIQUE, UNKNOWN, UNLOCK, UNINSTALL, UNSIGNED, UNTIL, UPDATE, UPGRADE, USAGE, USE, USER, USER_RESOURCES, USER_STATISTICS, USE_FRM, USING, UTC_DATE, UTC_TIME, UTC_TIMESTAMP, VALUE, VALUES, VARBINARY, VARCHAR, VARCHARACTER, VARIABLES, VARYING, VIA, VIEW, VIRTUAL, WAIT, WARNINGS, WEEK, WEIGHT_STRING, WHEN, WHERE, WHILE, WITH, WORK, WRAPPER, WRITE, X509, XOR, XA, XML, YEAR, YEAR_MONTH, ZEROFILL, ||, BOOST

赞 (0)
上一篇 4天前
下一篇 4天前