Reserved Words

Before getting to far into planning, there is a number of words that you cannot use for your table and column names. MySQL uses some specific words for command processing, so using them in your own coding may confuse things a bit.

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