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