O ApsaraDB RDS proíbe o uso de certas palavras-chave como identificadores de bancos de dados, contas, tabelas e colunas. Essa lista inclui palavras reservadas padrão do SQL e identificadores internos específicos do RDS.
ApsaraDB RDS for MySQL
Algumas palavras-chave nesta lista são identificadores internos específicos do RDS — como EAGLEYE, GUEST, GOTO, LABEL, MYSQL, REPLICATOR, ROOT, TEST e XTRABAK — que não são reservadas no MySQL padrão. O ApsaraDB RDS reserva esses termos para contas e componentes internos do sistema.
|
**Categoria** |
**Palavra-chave** |
|
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 |
|
Categoria |
Palavra-chave |
|
A |
accessible, account, action, actual, add, adddate, admin, after, against, aggregate, all, algorithm, alter, analyze, analyze, analyze, and, any, as, asc, ascii, ascii, sensitive, at, auto_increment, autoextend_size, avg, and avg_row_length |
|
B |
backup, before, begin, between, bigint, binary, binlog, bit, bit_and, bit_or, bit_xor, bka, blob, block, bnl, bool, boolean, both, btree, by, and byte |
|
C |
cache, call, cascade, cascaded, case, cast, catalog_name, chain, change, changed, channel, char, character, charset, check, checksum, cipher, class_origin, client, close, accommodation, code, collate, collation, column, column_format, column_name, columns, comment, comment, comment, comment, compress, compression, compression, compression, configuration, condition, and condition constraint, constraint_catalog, constraint_name, constraint_schema, contains, context, continue, convert, count, cpu, crie, cross, cube, curdate, current_date, current_time, current_timestamp, current_user, cursor, cursor_name, and curtime |
|
D |
data, date_add, date_sub, database, databases, datafile, date, datetime, day, day_hour, day_microsecond, day_minute, day_second, deallocate, dec, decimal, declare, default, default_auth, definer, delayed, delay_key_write, exclua, desc, describe, des_key_file, deterministic, diagnostics, directory, disable, discard, disk, distinct, distinctrow, div, dissolved oxygen (do), double, drop, dual, dumpfile, duplicate, dupsweedout, and dynamic |
|
E |
each, eagleye, else, elseif, ative, closed, end, ends, engine, engines, enum, error, errors, escape, escaped, event, events, every, exchange, execute, exists, exit, expansion, export, fire, explain, extended, extent_size, and extract |
|
F |
false, fast, faults, fetch, fields, file, file_block_size, filter, first, firstmatch, fixed, float, float4, float8, flush, follow, for, force, foreign, format, found, from, full, fulltext, and function |
|
G |
general, group_replication, geometry, geometrycollection, get_format, get, generated, global, goto, grant, grants, group, and group_concat |
|
H |
handler, hash, having, help, high_priority, host, hosts, hour, hour_microsecond, hour_minute, and hour_second |
|
I |
identified, if, ignore, ignore_server_ids, import, in, index, indexes, infile, information_schema, initial_size, inner, inout, insensitive, insert, insert_method, instale, instance, int, int1, int2, int3, int4, int8, integer, interval, into, intoexists, io, io_after_gtids, io_before_gtids, io_thread, ipc, is, isolation, issuer, iterate, and invoker |
|
J |
join, json, json_arrayagg, and json_objectagg |
|
K |
key, keys, key_block_size, and kill |
|
L |
label, label, language, last, leading, leave, leaves, left, less, level, like, limit, linear, lines, linestring, list, load, local, localtime, localtimestamp, lock, locks, logfile, logs, long, longblob, longtext, loop, loosescan, and low_priority |
|
M |
master, master_auto_position, master_bind, master_connect_retry, master_delay, master_host, master_log_file, master_log_pos, master_password, master_port, master_retry_count, master_server_id, master_ssl, master_ssl_ca, master_ssl_capath, master_tls_version, master_ssl_cert, master_ssl_cipher, master_ssl_crl, master_ssl_crlpath, master_ssl_key, master_ssl_verify_server_cert, master_user, master_heartbeat_period, match, materialization, max, max_connections_per_hour, max_execution_time, 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, mid, middleint, migrate, min, minute, minute_microsecond, minute_second, min_rows, mod, mode, modifications, modifique, month, mrr, multilinestring, multipoint, multipolygon, mutex, mysql, and mysql_errno |
|
N |
name, names, national, natural, ndb, ndbcluster, nchar, never, new, next, no, no_wait, nodegroup, none, not, now, no_bka, no_bnl, no_icp, no_mrr, no_range_optimization, no_semijoin, no_write_to_binlog, null, number, numeric, and nvarchar |
|
O |
offset, on, one, only, open, optimize, optimizer_costs, options, option, optional, or, order, out, outer, outfile, and owner |
|
P |
pack_keys, parser, page, parse_gcol_expr, partial, partition, partitioning, partition, password, performance_schema, phase, plugin, plugins, plugin_dir, point, polygon, port, position, precedes, prepare, preserve, prev, primary, privileges, procedure, process, process, processlist, profile, profiles, proxies, and purge |
|
Q |
qb_name, quarter, query, and quick |
|
R |
range, raid0, rds_add_proxy_protocol_networks, rds_audit, rds_change_user, rds_charsetnum, rds_connection_id, rds_current_connection, rds_db, rds_host_show, rds_inner_backup, rds_ip, rds_prepare_begin_id, rds_resetconnection, rds_rw_mode, rds_show_proxy_protocol_ips, rds_user, read, read_only, read_write, reads, real, rebuild, recover, redo_buffer_size, redoile, redundant, references, regexp, relaylog, relay_log_file, relay_log_pos, relay_thread, release, reload, repeatable, replace, replication, replicator, replicate_do_db, replicate_ignore_db, replicate_do_table, replicate_ignore_table, replicate_wild_do_table, replicate_wild_ignore_table, replicate_rewrite_db, repeat, require, reset, reset, restore, restrict, resume, returned_sqlstate, return, reverse, revoke, right, rlike, rollback, rollup, root, route, rotate, row, row, row, row, row, row, row, row, row, row, row_format, and rtree |
|
S |
savepoint, schedule, schema, schema_name, schemas, second, second_microsecond, security, selecione, semijoin, sensitive, separator, serial, serializable, session, server, session_user, defina, share, show, shutdown, signal, signed, simple, slave, slow, snapshot, socket, some, sql_after_gtids, qlsave, sql_after_mts_gaps, sql_before_gtids, sql_big_result, sql_buffer_result, sql_cache, sql_calc_found_rows, sql_filters, 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, stacked, start, start, start, start, start, stats_auto_recalc, stats_persistent, stats_sample_pages, status, stddev, stddev_pop, stddev_amp, stop, storage, stored_join, string, subclass_origin, subject, bid, subpartitions, subquery, substr, substring, sum, super, suspend, swaps, switches, sync, sysdate, and system_user |
|
T |
table, table_name, tables, tablespace, table_checksum, temporary, temptable, terminated, test, text, than, then, time, timestamp, timestampadd, timestampdiff, tinyblob, tinyint, tinytext, to, trafficking, transaction, trigger, triggers, triggers, true, truncate, type, and types |
|
U |
uncommitted, undefined, undo_buffer_size, undofile, undo, unicode, union, unique, unknown, unlock, uninstall, unsigned, until, atualize, upgrade, usage, use, user, user_resources, use_frm, using, utc_date, utc_time, and utc_timestamp |
|
V |
validation, value, values, var_pop, var_samp, varbinary, varchar, varcharacter, variables, variances, varying, visualize, and virtual |
|
W |
wait, warnings, week, weight_string, when, where, while, with, without, work, wrapper, and write |
|
X |
x509, xor, xa, xid, xml, and xtrabak |
|
Y |
year and year_month |
|
Z |
zerofill |
ApsaraDB RDS for SQL Server
Algumas palavras-chave nesta lista são identificadores internos específicos do RDS — como AURORA, EAGLEYE, GALAXY, SA, ROOT, ADMIN, ADMINISTRATOR, BULKADMIN, DBCREATOR, DISKADMIN, DISTRIBUTION, DUMMY, MSSQLD, MSSQLSYSTEMRESOURCE, PROCESSADMIN, SECURITYADMIN, SERVERADMIN, SETUPADMIN e SYSADMIN — que não são reservadas no SQL Server padrão. O ApsaraDB RDS reserva esses termos para contas e componentes internos do sistema.
|
**Categoria** |
**Palavra-chave** |
|
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
Para obter a lista completa de palavras reservadas, consulte a documentação oficial do PostgreSQL.