ApsaraDB RDS reserves certain keywords that you cannot use as identifiers — for example, database names, table names, usernames, or other object names. These keywords include standard SQL reserved words and internal system identifiers specific to ApsaraDB RDS. If you use a forbidden keyword as an identifier, the operation fails.
The following lists cover ApsaraDB RDS for MySQL and ApsaraDB RDS for SQL Server. For ApsaraDB RDS for PostgreSQL, see the PostgreSQL official documentation.
ApsaraDB RDS for MySQL
| Category | Keyword |
|---|---|
| A | ACTION, ADD, ADMIN, ALL, ALTER, ANALYZE, AND, AS, ASC, ASENSITIVE |
| B | BEFORE, BETWEEN, BIGINT, BINARY, BLOB, BOTH, BY |
| C | CALL, CASCADE, CASE, CHANGE, CHAR, CHARACTER, CHECK, COLLATE, COLUMN, CONDITION, CONNECTION, CONSTRAINT, CONTINUE, CONVERT, CREATE, CROSS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR |
| D | DATABASE, DATABASES, DAY_HOUR, DAY_MICROSECOND, DAY_MINUTE, DAY_SECOND, DEC, DECIMAL, DECLARE, DEFAULT, DELAYED, DELETE, DESC, DESCRIBE, DETERMINISTIC, DISTINCT, DISTINCTROW, DIV, DOUBLE, DROP, DUAL |
| E | EACH, EAGLEYE, ELSE, ELSEIF, ENCLOSED, ESCAPED, EXISTS, EXIT, EXPLAIN |
| F | FALSE, FETCH, FLOAT, FLOAT4, FLOAT8, FOR, FORCE, FOREIGN, FROM, FULLTEXT |
| G | GOTO, GRANT, GROUP, GUEST |
| H | HAVING, HIGH_PRIORITY, HOUR_MICROSECOND, HOUR_MINUTE, HOUR_SECOND |
| I | IF, IGNORE, IN, INDEX, INFILE, INFORMATION_SCHEMA, INNER, INOUT, INSENSITIVE, INSERT, INT, INT1, INT2, INT3, INT4, INT8, INTEGER, INTERVAL, INTO, IS, ITERATE |
| J | JOIN |
| K | KEY, KEYS, KILL |
| L | LABEL, LEADING, LEAVE, LEFT, LIKE, LIMIT, LINEAR, LINES, LOAD, LOCALTIME, LOCALTIMESTAMP, LOCK, LONG, LONG, LONGBLOB, LONGTEXT, LOOP, LOW_PRIORITY |
| M | MATCH, MEDIUMBLOB, MEDIUMINT, MEDIUMTEXT, MIDDLEINT, MINUTE_MICROSECOND, MINUTE_SECOND, MOD, MODIFIES, MYSQL |
| N | NATURAL, NO_WRITE_TO_BINLOG, NOT, NULL, NUMERIC |
| O | ON, OPTIMIZE, OPTION, OPTIONALLY, OR, ORDER, OUT, OUTER, OUTFILE |
| P | PERFORMANCE_SCHEMA, PRECISION, PRIMARY, PROCEDURE, PURGE |
| R | RAID0, RANGE, READ, READS, REAL, REFERENCES, REGEXP, RELEASE, RENAME, REPEAT, REPLACE, REPLICATOR, REQUIRE, RESTRICT, RETURN, REVOKE, RIGHT, RLIKE, ROOT |
| S | SCHEMA, SCHEMAS, SECOND_MICROSECOND, SELECT, SENSITIVE, SEPARATOR, SET, SHOW, SMALLINT, SPATIAL, SPECIFIC, SQL, SQL_BIG_RESULT, SQL_CALC_FOUND_ROWS, SQL_SMALL_RESULT, SQLEXCEPTION, SQLSTATE, SQLWARNING, SSL, STARTING, STRAIGHT_JOIN |
| T | TABLE, TERMINATED, TEST, THEN, TINYBLOB, TINYINT, TINYTEXT, TO, TRAILING, TRIGGER, TRUE |
| U | UNDO, UNION, UNIQUE, UNLOCK, UNSIGNED, UPDATE, USAGE, USE, USING, UTC_DATE, UTC_TIME, UTC_TIMESTAMP |
| V | VALUES, VARBINARY, VARCHAR, VARCHARACTER, VARYING |
| W | WHEN, WHERE, WHILE, WITH, WRITE |
| X | X509, XOR, XTRABAK |
| Y | YEAR_MONTH |
| Z | ZEROFILL |
ApsaraDB RDS for SQL Server
| Category | Keyword |
|---|---|
| A | ADD, ADMIN, ADMINISTRATOR, ALL, ALTER, AND, ANY, AS, ASC, AURORA, AUTHORIZATION |
| B | BACKUP, BEGIN, BETWEEN, BREAK, BROWSE, BULK, BULKADMIN, BY |
| C | CASCADE, CASE, CHECK, CHECKPOINT, CLOSE, CLUSTERED, COALESCE, COLLATE, COLUMN, COMMIT, COMPUTE, CONSTRAINT, CONTAINS, CONTAINSTABLE, CONTINUE, CONTINUE, CONVERT, CREATE, CROSS, CURRENT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, CURRENT_USER, CURSOR |
| D | DATABASE, DBCC, DBCREATOR, DEALLOCATE, DECLARE, DEFAULT, DELETE, DENY, DESC, DISK, DISKADMIN, DISTINCT, DISTRIBUTED, DISTRIBUTION, DOUBLE, DROP, DUMMY, DUMP |
| E | EAGLEYE, ELSE, END, ERRLVL, ESCAPE, EXCEPT, EXEC, EXECUTE, EXISTS, EXIT |
| F | FETCH, FILE, FILLFACTOR, FOR, FOREIGN, FREETEXT, FREETEXTTABLE, FROM, FULL, FUNCTION |
| G | GALAXY, GOTO, GRANT, GROUP, GUEST |
| H | HAVING, HOLDLOCK |
| I | IDENTITY, IDENTITY_INSERT, IDENTITYCOL, IF, IN, INDEX, INNER, INSERT, INTERSECT, INTO, IS |
| J | JOIN |
| K | KEY, KILL |
| L | LEFT, LIKE, LINENO, LOAD |
| M | MASTER, MODEL, MSDB, MSSQLD, MSSQLSYSTEMRESOURCE |
| N | NATIONAL, NOCHECK, NONCLUSTERED, NOT, NULL, NULLIF |
| O | OF, OFF, OFFSETS, ON, OPEN, OPENDATASOURCE, OPENQUERY, OPENROWSET, OPENXML, OPTION, OR, ORDER, OUTER, OVER |
| P | PERCENT, PLAN, PRECISION, PRIMARY, PRINT, PROC, PROCEDURE, PROCESSADMIN, PUBLIC, PUBLIC |
| R | RAISERROR, READ, READTEXT, RECONFIGURE, REFERENCES, REPLICATION, RESTORE, RESTRICT, RETURN, REVOKE, RIGHT, ROLLBACK, ROOT, ROWCOUNT, ROWGUIDCOL, RULE |
| S | SA, SAVE, SCHEMA, SECURITYADMIN, SELECT, SERVERADMIN, SESSION_USER, SET, SETUPADMIN, SETUSER, SHUTDOWN, SOME, STATISTICS, SYSADMIN, SYSTEM_USER |
| T | TABLE, TEMPDB, TEXTSIZE, THEN, TO, TOP, TRAN, TRANSACTION, TRIGGER, TRUNCATE, TSEQUAL |
| U | UNION, UNIQUE, UPDATE, UPDATETEXT, USE, USER |
| V | VALUES, VARYING, VIEW |
| W | WAITFOR, WHEN, WHERE, WHILE, WITH, WRITETEXT |
ApsaraDB RDS for PostgreSQL
For the complete list of reserved keywords, see the PostgreSQL official documentation.
该文章对您有帮助吗？