MySQL 키워드 및 예약어 정리 표

 

출처 oracle site
https://docs.oracle.com/cd/E17952_01/mysql-5.1-en/keywords.html

LOCK (R)	LOCKS	LOGFILE[z]
LOGS	LONG (R)	LONGBLOB (R)
LONGTEXT (R)	LOOP (R)	LOW_PRIORITY (R)
MASTER	MASTER_CONNECT_RETRY	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_KEY	MASTER_SSL_VERIFY_SERVER_CERT[aa] (R)
MASTER_USER	MATCH (R)	MAXVALUE
MAX_CONNECTIONS_PER_HOUR	MAX_QUERIES_PER_HOUR	MAX_ROWS
MAX_SIZE[ab]	MAX_UPDATES_PER_HOUR	MAX_USER_CONNECTIONS
MEDIUM	MEDIUMBLOB (R)	MEDIUMINT (R)
MEDIUMTEXT (R)	MEMORY[ac]	MERGE
MICROSECOND	MIDDLEINT (R)	MIGRATE
MINUTE	MINUTE_MICROSECOND (R)	MINUTE_SECOND (R)
MIN_ROWS	MOD (R)	MODE
MODIFIES (R)	MODIFY	MONTH
MULTILINESTRING	MULTIPOINT	MULTIPOLYGON
MUTEX	NAME	NAMES
NATIONAL	NATURAL (R)	NCHAR
NDB	NDBCLUSTER	NEW
NEXT	NO	NODEGROUP
NONE	NOT (R)	NO_WAIT[ad]
NO_WRITE_TO_BINLOG (R)	NULL (R)	NUMERIC (R)
NVARCHAR	OFFSET	OLD_PASSWORD
ON (R)	ONE	ONE_SHOT
OPEN	OPTIMIZE (R)	OPTION (R)
OPTIONALLY (R)	OPTIONS[ae]	OR (R)
ORDER (R)	OUT (R)	OUTER (R)
OUTFILE (R)	OWNER[af]	PACK_KEYS
PAGE[ag]	PAGE_CHECKSUM[ah]	PARSER
PARTIAL	PARTITION	PARTITIONING[ai]
PARTITIONS	PASSWORD	PHASE
PLUGIN	PLUGINS[aj]	POINT
POLYGON	PORT[ak]	PRECISION (R)
PREPARE	PRESERVE[al]	PREV
PRIMARY (R)	PRIVILEGES	PROCEDURE (R)
PROCESSLIST	PROFILE[am]	PROFILES[an]
PURGE (R)	QUARTER	QUERY
QUICK	RAID0[ao]	RAID_CHUNKS[ap]
RAID_CHUNKSIZE[aq]	RAID_TYPE[ar]	RANGE (R)
READ (R)	READS (R)	READ_ONLY[as]
READ_WRITE[at] (R)	REAL (R)	REBUILD[au]
RECOVER	REDOFILE[av]	REDO_BUFFER_SIZE[aw]
REDUNDANT	REFERENCES (R)	REGEXP (R)
RELAY_LOG_FILE	RELAY_LOG_POS	RELAY_THREAD
RELEASE (R)	RELOAD	REMOVE[ax]
RENAME (R)	REORGANISE[ay]	REORGANIZE[az]
REPAIR	REPEAT (R)	REPEATABLE
REPLACE (R)	REPLICATION	REQUIRE (R)
RESET	RESTORE	RESTRICT (R)
RESUME	RETURN (R)	RETURNS
REVOKE (R)	RIGHT (R)	RLIKE (R)
ROLLBACK	ROLLUP	ROUTINE
ROW	ROWS	ROW_FORMAT
RTREE	SAVEPOINT	SCHEDULE[ba]
SCHEDULER[bb]	SCHEMA (R)	SCHEMAS (R)
SECOND	SECOND_MICROSECOND (R)	SECURITY
SELECT (R)	SENSITIVE (R)	SEPARATOR (R)
SERIAL	SERIALIZABLE	SERVER[bc]
SESSION	SET (R)	SHARE
SHOW (R)	SHUTDOWN	SIGNED
SIMPLE	SLAVE	SMALLINT (R)
SNAPSHOT	SOCKET[bd]	SOME
SONAME	SOUNDS	SOURCE[be]
SPATIAL (R)	SPECIFIC (R)	SQL (R)
SQLEXCEPTION (R)	SQLSTATE (R)	SQLWARNING (R)
SQL_BIG_RESULT (R)	SQL_BUFFER_RESULT	SQL_CACHE
SQL_CALC_FOUND_ROWS (R)	SQL_NO_CACHE	SQL_SMALL_RESULT (R)
SQL_THREAD	SQL_TSI_DAY	SQL_TSI_FRAC_SECOND
SQL_TSI_HOUR	SQL_TSI_MINUTE	SQL_TSI_MONTH
SQL_TSI_QUARTER	SQL_TSI_SECOND	SQL_TSI_WEEK
SQL_TSI_YEAR	SSL (R)	START
STARTING (R)	STARTS[bf]	STATUS
STOP	STORAGE	STRAIGHT_JOIN (R)
STRING	STRIPED[bg]	SUBJECT
SUBPARTITION	SUBPARTITIONS	SUPER
SUSPEND	SWAPS[bh]	SWITCHES[bi]
TABLE (R)	TABLES	TABLESPACE
TABLE_CHECKSUM[bj]	TEMPORARY	TEMPTABLE
TERMINATED (R)	TEXT	THAN
THEN (R)	TIME	TIMESTAMP
TIMESTAMPADD	TIMESTAMPDIFF	TINYBLOB (R)
TINYINT (R)	TINYTEXT (R)	TO (R)
TRAILING (R)	TRANSACTION	TRANSACTIONAL[bk]
TRIGGER (R)	TRIGGERS	TRUE (R)
TRUNCATE	TYPE	TYPES
UNCOMMITTED	UNDEFINED	UNDO (R)
UNDOFILE[bl]	UNDO_BUFFER_SIZE[bm]	UNICODE
UNINSTALL	UNION (R)	UNIQUE (R)
UNKNOWN	UNLOCK (R)	UNSIGNED (R)
UNTIL	UPDATE (R)	UPGRADE[bn]
USAGE (R)	USE (R)	USER
USER_RESOURCES	USE_FRM	USING (R)
UTC_DATE (R)	UTC_TIME (R)	UTC_TIMESTAMP (R)
VALUE	VALUES (R)	VARBINARY (R)
VARCHAR (R)	VARCHARACTER (R)	VARIABLES
VARYING (R)	VIEW	WAIT[bo]
WARNINGS	WEEK	WHEN (R)
WHERE (R)	WHILE (R)	WITH (R)
WORK	WRAPPER[bp]	WRITE (R)
X509	XA	XOR (R)
YEAR	YEAR_MONTH (R)	ZEROFILL (R)
ACCESSIBLE (R)	AT	AUTHORS
AUTOEXTEND_SIZE	COALESCE	COMPLETION
CONTRIBUTORS	DATAFILE	DISK
ENDS	EVENT	EVERY
EXTENT_SIZE	HOST	INITIAL_SIZE
INSTALL	KEY_BLOCK_SIZE	LESS
LINEAR (R)	LIST	LOGFILE
MASTER_SSL_VERIFY_SERVER_CERT (R)	MAXVALUE	MAX_SIZE
NODEGROUP	NO_WAIT	OPTIONS
OWNER	PARSER	PARTITION
PARTITIONING	PARTITIONS	PLUGIN
PLUGINS	PORT	PRESERVE
RANGE (R)	READ_ONLY	READ_WRITE (R)
REBUILD	REDOFILE	REDO_BUFFER_SIZE
REMOVE	REORGANIZE	SCHEDULE
SERVER	SOCKET	STARTS
SUBPARTITION	SUBPARTITIONS	TABLE_CHECKSUM
THAN	UNDOFILE	UNDO_BUFFER_SIZE
UNINSTALL	WAIT	WRAPPER
BDB	BERKELEYDB	RAID0
RAID_CHUNKS	RAID_CHUNKSIZE	RAID_TYPE
STRIPED