此文章将列出 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