有奖捉虫:办公协同&微信生态&物联网文档专题 HOT
此文章将列出 TDSQL MySQL 版当前所涉及的保留关键字,在SQL中使用时需添加 ‘’ 才能被 Proxy 解析。
主要保留关键字变更记录
关键字
变更内容
引入版本
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