রিজার্ভড কিওয়ার্ড এর তালিকা
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) | - |