· 7 years ago · Jan 28, 2019, 08:44 AM
1# ---------------------------------------
2# MySQL 8.0 Keywords and Reserved Words
3# ---------------------------------------
4
5ACCESSIBLE
6ACCOUNT
7ACTION
8ACTIVE
9ADD
10ADMIN
11AFTER
12AGAINST
13AGGREGATE
14ALGORITHM
15ALL
16ALTER
17ALWAYS
18ANALYSE
19ANALYZE
20AND
21ANY
22AS
23ASC
24ASCII
25ASENSITIVE
26AT
27AUTOEXTEND_SIZE
28AUTO_INCREMENT
29AVG
30AVG_ROW_LENGTH
31BACKUP
32BEFORE
33BEGIN
34BETWEEN
35BIGINT
36BINARY
37BINLOG
38BIT
39BLOB
40BLOCK
41BOOL
42BOOLEAN
43BOTH
44BTREE
45BUCKETS
46BY
47BYTE
48CACHE
49CALL
50CASCADE
51CASCADED
52CASE
53CATALOG_NAME
54CHAIN
55CHANGE
56CHANGED
57CHANNEL
58CHAR
59CHARACTER
60CHARSET
61CHECK
62CHECKSUM
63CIPHER
64CLASS_ORIGIN
65CLIENT
66CLONE
67CLOSE
68COALESCE
69CODE
70COLLATE
71COLLATION
72COLUMN
73COLUMNS
74COLUMN_FORMAT
75COLUMN_NAME
76COMMENT
77COMMIT
78COMMITTED
79COMPACT
80COMPLETION
81COMPONENT
82COMPRESSED
83COMPRESSION
84CONCURRENT
85CONDITION
86CONNECTION
87CONSISTENT
88CONSTRAINT
89CONSTRAINT_CATALOG
90CONSTRAINT_NAME
91CONSTRAINT_SCHEMA
92CONTAINS
93CONTEXT
94CONTINUE
95CONVERT
96CPU
97CREATE
98CROSS
99CUBE
100CUME_DIST
101CURRENT
102CURRENT_DATE
103CURRENT_TIME
104CURRENT_TIMESTAMP
105CURRENT_USER
106CURSOR
107CURSOR_NAME
108DATA
109DATABASE
110DATABASES
111DATAFILE
112DATE
113DATETIME
114DAY
115DAY_HOUR
116DAY_MICROSECOND
117DAY_MINUTE
118DAY_SECOND
119DEALLOCATE
120DEC
121DECIMAL
122DECLARE
123DEFAULT
124DEFAULT_AUTH
125DEFINER
126DEFINITION
127DELAYED
128DELAY_KEY_WRITE
129DELETE
130DENSE_RANK
131DESC
132DESCRIBE
133DESCRIPTION
134DES_KEY_FILE
135DETERMINISTIC
136DIAGNOSTICS
137DIRECTORY
138DISABLE
139DISCARD
140DISK
141DISTINCT
142DISTINCTROW
143DIV
144DO
145DOUBLE
146DROP
147DUAL
148DUMPFILE
149DUPLICATE
150DYNAMIC
151EACH
152ELSE
153ELSEIF
154EMPTY
155ENABLE
156ENCLOSED
157ENCRYPTION
158END
159ENDS
160ENFORCED
161ENGINE
162ENGINES
163ENUM
164ERROR
165ERRORS
166ESCAPE
167ESCAPED
168EVENT
169EVENTS
170EVERY
171EXCEPT
172EXCHANGE
173EXCLUDE
174EXECUTE
175EXISTS
176EXIT
177EXPANSION
178EXPIRE
179EXPLAIN
180EXPORT
181EXTENDED
182EXTENT_SIZE
183FALSE
184FAST
185FAULTS
186FETCH
187FIELDS
188FILE
189FILE_BLOCK_SIZE
190FILTER
191FIRST
192FIRST_VALUE
193FIXED
194FLOAT
195FLOAT4
196FLOAT8
197FLUSH
198FOLLOWING
199FOLLOWS
200FOR
201FORCE
202FOREIGN
203FORMAT
204FOUND
205FROM
206FULL
207FULLTEXT
208FUNCTION
209GENERAL
210GENERATED
211GEOMCOLLECTION
212GEOMETRY
213GEOMETRYCOLLECTION
214GET
215GET_FORMAT
216GET_MASTER_PUBLIC_KEY
217GLOBAL
218GRANT
219GRANTS
220GROUP
221GROUPING
222GROUPS
223GROUP_REPLICATION
224HANDLER
225HASH
226HAVING
227HELP
228HIGH_PRIORITY
229HISTOGRAM
230HISTORY
231HOST
232HOSTS
233HOUR
234HOUR_MICROSECOND
235HOUR_MINUTE
236HOUR_SECOND
237IDENTIFIED
238IF
239IGNORE
240IGNORE_SERVER_IDS
241IMPORT
242IN
243INACTIVE
244INDEX
245INDEXES
246INFILE
247INITIAL_SIZE
248INNER
249INOUT
250INSENSITIVE
251INSERT
252INSERT_METHOD
253INSTALL
254INSTANCE
255INT
256INT1
257INT2
258INT3
259INT4
260INT8
261INTEGER
262INTERVAL
263INTO
264INVISIBLE
265INVOKER
266IO
267IO_AFTER_GTIDS
268IO_BEFORE_GTIDS
269IO_THREAD
270IPC
271IS
272ISOLATION
273ISSUER
274ITERATE
275JOIN
276JSON
277JSON_TABLE
278KEY
279KEYS
280KEY_BLOCK_SIZE
281KILL
282LAG
283LANGUAGE
284LAST
285LAST_VALUE
286LATERAL
287LEAD
288LEADING
289LEAVE
290LEAVES
291LEFT
292LESS
293LEVEL
294LIKE
295LIMIT
296LINEAR
297LINES
298LINESTRING
299LIST
300LOAD
301LOCAL
302LOCALTIME
303LOCALTIMESTAMP
304LOCK
305LOCKED
306LOCKS
307LOGFILE
308LOGS
309LONG
310LONGBLOB
311LONGTEXT
312LOOP
313LOW_PRIORITY
314MASTER
315MASTER_AUTO_POSITION
316MASTER_BIND
317MASTER_CONNECT_RETRY
318MASTER_DELAY
319MASTER_HEARTBEAT_PERIOD
320MASTER_HOST
321MASTER_LOG_FILE
322MASTER_LOG_POS
323MASTER_PASSWORD
324MASTER_PORT
325MASTER_PUBLIC_KEY_PATH
326MASTER_RETRY_COUNT
327MASTER_SERVER_ID
328MASTER_SSL
329MASTER_SSL_CA
330MASTER_SSL_CAPATH
331MASTER_SSL_CERT
332MASTER_SSL_CIPHER
333MASTER_SSL_CRL
334MASTER_SSL_CRLPATH
335MASTER_SSL_KEY
336MASTER_SSL_VERIFY_SERVER_CERT
337MASTER_TLS_VERSION
338MASTER_USER
339MATCH
340MAXVALUE
341MAX_CONNECTIONS_PER_HOUR
342MAX_QUERIES_PER_HOUR
343MAX_ROWS
344MAX_SIZE
345MAX_UPDATES_PER_HOUR
346MAX_USER_CONNECTIONS
347MEDIUM
348MEDIUMBLOB
349MEDIUMINT
350MEDIUMTEXT
351MEMORY
352MERGE
353MESSAGE_TEXT
354MICROSECOND
355MIDDLEINT
356MIGRATE
357MINUTE
358MINUTE_MICROSECOND
359MINUTE_SECOND
360MIN_ROWS
361MOD
362MODE
363MODIFIES
364MODIFY
365MONTH
366MULTILINESTRING
367MULTIPOINT
368MULTIPOLYGON
369MUTEX
370MYSQL_ERRNO
371NAME
372NAMES
373NATIONAL
374NATURAL
375NCHAR
376NDB
377NDBCLUSTER
378NESTED
379NEVER
380NEW
381NEXT
382NO
383NODEGROUP
384NONE
385NOT
386NOWAIT
387NO_WAIT
388NO_WRITE_TO_BINLOG
389NTH_VALUE
390NTILE
391NULL
392NULLS
393NUMBER
394NUMERIC
395NVARCHAR
396OF
397OFFSET
398OJ
399OLD
400ON
401ONE
402ONLY
403OPEN
404OPTIMIZE
405OPTIMIZER_COSTS
406OPTION
407OPTIONAL
408OPTIONALLY
409OPTIONS
410OR
411ORDER
412ORDINALITY
413ORGANIZATION
414OTHERS
415OUT
416OUTER
417OUTFILE
418OVER
419OWNER
420PACK_KEYS
421PAGE
422PARSER
423PARTIAL
424PARTITION
425PARTITIONING
426PARTITIONS
427PASSWORD
428PATH
429PERCENT_RANK
430PERSIST
431PERSIST_ONLY
432PHASE
433PLUGIN
434PLUGINS
435PLUGIN_DIR
436POINT
437POLYGON
438PORT
439PRECEDES
440PRECEDING
441PRECISION
442PREPARE
443PRESERVE
444PREV
445PRIMARY
446PRIVILEGES
447PROCEDURE
448PROCESS
449PROCESSLIST
450PROFILE
451PROFILES
452PROXY
453PURGE
454QUARTER
455QUERY
456QUICK
457RANGE
458RANK
459READ
460READS
461READ_ONLY
462READ_WRITE
463REAL
464REBUILD
465RECOVER
466RECURSIVE
467REDOFILE
468REDO_BUFFER_SIZE
469REDUNDANT
470REFERENCE
471REFERENCES
472REGEXP
473RELAY
474RELAYLOG
475RELAY_LOG_FILE
476RELAY_LOG_POS
477RELAY_THREAD
478RELEASE
479RELOAD
480REMOTE
481REMOVE
482RENAME
483REORGANIZE
484REPAIR
485REPEAT
486REPEATABLE
487REPLACE
488REPLICATE_DO_DB
489REPLICATE_DO_TABLE
490REPLICATE_IGNORE_DB
491REPLICATE_IGNORE_TABLE
492REPLICATE_REWRITE_DB
493REPLICATE_WILD_DO_TABLE
494REPLICATE_WILD_IGNORE_TABLE
495REPLICATION
496REQUIRE
497RESET
498RESIGNAL
499RESOURCE
500RESPECT
501RESTART
502RESTORE
503RESTRICT
504RESUME
505RETAIN
506RETURN
507RETURNED_SQLSTATE
508RETURNS
509REUSE
510REVERSE
511REVOKE
512RIGHT
513RLIKE
514ROLE
515ROLLBACK
516ROLLUP
517ROTATE
518ROUTINE
519ROW
520ROWS
521ROW_COUNT
522ROW_FORMAT
523ROW_NUMBER
524RTREE
525SAVEPOINT
526SCHEDULE
527SCHEMA
528SCHEMAS
529SCHEMA_NAME
530SECOND
531SECONDARY
532SECONDARY_ENGINE
533SECONDARY_LOAD
534SECONDARY_UNLOAD
535SECOND_MICROSECOND
536SECURITY
537SELECT
538SENSITIVE
539SEPARATOR
540SERIAL
541SERIALIZABLE
542SERVER
543SESSION
544SET
545SHARE
546SHOW
547SHUTDOWN
548SIGNAL
549SIGNED
550SIMPLE
551SKIP
552SLAVE
553SLOW
554SMALLINT
555SNAPSHOT
556SOCKET
557SOME
558SONAME
559SOUNDS
560SOURCE
561SPATIAL
562SPECIFIC
563SQL
564SQLEXCEPTION
565SQLSTATE
566SQLWARNING
567SQL_AFTER_GTIDS
568SQL_AFTER_MTS_GAPS
569SQL_BEFORE_GTIDS
570SQL_BIG_RESULT
571SQL_BUFFER_RESULT
572SQL_CACHE
573SQL_CALC_FOUND_ROWS
574SQL_NO_CACHE
575SQL_SMALL_RESULT
576SQL_THREAD
577SQL_TSI_DAY
578SQL_TSI_HOUR
579SQL_TSI_MINUTE
580SQL_TSI_MONTH
581SQL_TSI_QUARTER
582SQL_TSI_SECOND
583SQL_TSI_WEEK
584SQL_TSI_YEAR
585SRID
586SSL
587STACKED
588START
589STARTING
590STARTS
591STATS_AUTO_RECALC
592STATS_PERSISTENT
593STATS_SAMPLE_PAGES
594STATUS
595STOP
596STORAGE
597STORED
598STRAIGHT_JOIN
599STRING
600SUBCLASS_ORIGIN
601SUBJECT
602SUBPARTITION
603SUBPARTITIONS
604SUPER
605SUSPEND
606SWAPS
607SWITCHES
608SYSTEM
609TABLE
610TABLES
611TABLESPACE
612TABLE_CHECKSUM
613TABLE_NAME
614TEMPORARY
615TEMPTABLE
616TERMINATED
617TEXT
618THAN
619THEN
620THREAD_PRIORITY
621TIES
622TIME
623TIMESTAMP
624TIMESTAMPADD
625TIMESTAMPDIFF
626TINYBLOB
627TINYINT
628TINYTEXT
629TO
630TRAILING
631TRANSACTION
632TRIGGER
633TRIGGERS
634TRUE
635TRUNCATE
636TYPE
637TYPES
638UNBOUNDED
639UNCOMMITTED
640UNDEFINED
641UNDO
642UNDOFILE
643UNDO_BUFFER_SIZE
644UNICODE
645UNINSTALL
646UNION
647UNIQUE
648UNKNOWN
649UNLOCK
650UNSIGNED
651UNTIL
652UPDATE
653UPGRADE
654USAGE
655USE
656USER
657USER_RESOURCES
658USE_FRM
659USING
660UTC_DATE
661UTC_TIME
662UTC_TIMESTAMP
663VALIDATION
664VALUE
665VALUES
666VARBINARY
667VARCHAR
668VARCHARACTER
669VARIABLES
670VARYING
671VCPU
672VIEW
673VIRTUAL
674VISIBLE
675WAIT
676WARNINGS
677WEEK
678WEIGHT_STRING
679WHEN
680WHERE
681WHILE
682WINDOW
683WITH
684WITHOUT
685WORK
686WRAPPER
687WRITE
688X509
689XA
690XID
691XML
692XOR
693YEAR
694YEAR_MONTH
695ZEROFILL