MySQL Reserved Words

Good Day!!!! In this chapter of my tutorial, we will discuss all the Reserved Words in MySQL. SQL is a language that made up of keywords - special words that we used in performing SQL operations. We're not supposed used these keywords when naming a databases, tables, columns and any other database objects. Thus, these all keywords are considered reserved.

Reserved Words

These are the following Reserved Words in MySQL:

• ACCESSIBLE
• ADD
• ALL
• ALTER
• ANALYZE
• AND
• AS
• ASC
• ASENSITIVE
• BEFORE
• BETWEEN
• BIGINT
• BINARY
• BLOB
• BOTH
• BY
• CALL
• CASCADE
• CASE
• CHANGE
• CHAR
• CHARACTER
• CHECK
• COLLATE
• COLUMN
• CONDITION
• CONSTRAINT
• CONTINUE
• CONVERT
• CREATE
• CROSS
• CURRENT_DATE
• CURRENT_TIME
• CURRENT_TIMESTAMP
• CURRENT_USER
• CURSOR
• 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
• EACH
• ELSE
• ELSEIF
• ENCLOSED
• ESCAPED
• EXISTS
• EXIT
• EXPLAIN
• FALSE
• FETCH
• FLOAT
• FLOAT4
• FLOAT8
• FOR
• FORCE
• FOREIGN
• FROM
• FULLTEXT
• GRANT
• GROUP
• HAVING
• HIGH_PRIORITY
• HOUR_MICROSECOND
• HOUR_MINUTE
• HOUR_SECOND
• IF
• IGNORE
• IN
• INDEX
• INFILE
• INNER
• INOUT
• INSENSITIVE
• INSERT
• INT
• INT1
• INT2
• INT3
• INT4
• INT8
• INTEGER
• INTERVAL
• INTO
• IS
• ITERATE
• JOIN
• KEY
• KEYS
• KILL
• LEADING
• LEAVE
• LEFT
• LIKE
• LIMIT
• LINEAR
• LINES
• LOAD
• LOCALTIME
• LOCALTIMESTAMP
• LOCK
• LONG
• LONGBLOB
• LONGTEXT
• LOOP
• LOW_PRIORITY
• MASTER_SSL_VERIFY_SERVER_CERT
• MATCH
• MEDIUMBLOB
• MEDIUMINT
• MEDIUMTEXT
• MIDDLEINT
• MINUTE_MICROSECOND
• MINUTE_SECOND
• MOD
• MODIFIES
• NATURAL
• NOT
• NO_WRITE_TO_BINLOG
• NULL
• NUMERIC
• ON
• OPTIMIZE
• OPTION
• OPTIONALLY
• OR
• ORDER
• OUT
• OUTER
• OUTFILE
• PRECISION
• PRIMARY
• PROCEDURE
• PURGE
• RANGE
• READ
• READS
• READ_WRITE
• REAL
• REFERENCES
• REGEXP
• RELEASE
• RENAME
• REPEAT
• REPLACE
• REQUIRE
• RESTRICT
• RETURN
• REVOKE
• RIGHT
• RLIKE
• SCHEMA
• SCHEMAS
• SECOND_MICROSECOND
• SELECT
• SENSITIVE
• SEPARATOR
• SET
• SHOW
• SMALLINT
• SPATIAL
• SPECIFIC
• SQL
• SQLEXCEPTION
• SQLSTATE
• SQLWARNING
• SQL_BIG_RESULT
• SQL_CALC_FOUND_ROWS
• SQL_SMALL_RESULT
• SSL
• STARTING
• STRAIGHT_JOIN
• TABLE
• TERMINATED
• THEN
• TINYBLOB
• TINYINT
• TINYTEXT
• TO
• TRAILING
• TRIGGER
• TRUE
• UNDO
• UNION
• UNIQUE
• UNLOCK
• UNSIGNED
• UPDATE
• USAGE
• USE
• USING
• UTC_DATE
• UTC_TIME
• UTC_TIMESTAMP
• VALUES
• VARBINARY
• VARCHAR
• VARCHARACTER
• VARYING
• WHEN
• WHERE
• WHILE
• WITH
• WRITE
• XOR
• YEAR_MONTH
• ZEROFILL

For my next tutorial lets discuss the "Different kinds of Operators in MySQL". So what can you say about this tutorial? Share your thoughts in the comment section below and also, don’t forget to like this page. Thank you.