advertise here

Mysql Reserved Word lists

You can not use below keywords as mysql identifiers as table or column name. if you want to use as identifiers you have to use backticks quote

Example- CREATE TABLE  all (id INT, name VARCHAR(100));

above query out error beacuse ALL is a reserved word you should use bacticks(``)

Example- CREATE TABLE  `all` (id INT, name VARCHAR(100));

mysql reserved word list sql server oracle support more databases

A

  1. ADD
  2. ALL
  3. ALTER
  4. ANALYZE
  5. AND
  6. AS
  7. AUTO-INCREMENT

B

  1. BDB 
  2. BERKELEYDB 
  3. BETWEEN
  4. BIGINT
  5. BINARY
  6. BLOB
  7. BOTH
  8. BTREE
  9. BY

C

  1. CASE
  2. CHANGE
  3. CHAR
  4. CHARACTER
  5. CHECK
  6. COLLATE
  7. COLUMN
  8. COLUMNS
  9. CONSTRAINT
  10. CREATE
  11. CROSS
  12. CURRENT_DATE
  13. CURRENT_TIME
  14. CURRENT_TIMESTAMP

D

  1. DATABASE
  2. DAY_HOUR
  3. DAY_MINUTE
  4. DAY_SECOND
  5. DEC
  6. DECIMAL
  7. DEFULT
  8. DELAYED
  9. DELETE
  10. DESC
  11. DESCRIBE
  12. DISTINCT
  13. DISTINCTROW
  14. DIV
  15. DOUBLE
  16. DROP

E

  1. ELSE
  2. ENCLOSED
  3. ERRORS
  4. ESCAPED
  5. EXISTS
  6. EXPLAIN

F

  1. FALSE
  2. FIELDS
  3. FLOAT
  4. FOR
  5. FORCE
  6. FOREIGN
  7. FROM
  8. FULLTEXT
  9. FUNCTION

G

  1. GEOMETRY
  2. GRANT
  3. GROUP

H

  1. HASH
  2. HAVING
  3. HELP
  4. HIGH_PRIORITY
  5. HOUR_MINUTE
  6. HOUR_SECOND

I

  1. IF
  2. IGNORE
  3. IN
  4. INDEX
  5. INFILE
  6. INNER
  7. INNODB
  8. INSERT
  9. INT
  10. INTEGER
  11. INTERVAL
  12. INTO
  13. IS

J

  1. JOIN

K

  1. KEY
  2. KEYS
  3. KILL

L

  1. LEADING
  2. LEFT
  3. LIKE
  4. LIMIT
  5. LINES
  6. LOAD
  7. LOCALTIME
  8. LOCALTIMESTAMP
  9. LOCK
  10. LONG
  11. LONGBLOB
  12. LONGTEXT
  13. LOW_PRIORITY

M

  1. MASTER_SERVER_ID
  2. MATCH
  3. MEDIUMBLOB
  4. MIDIUMINT
  5. MIDIUMTEXT
  6. MIDDLEINT
  7. MINUTE_SECOND
  8. MOD
  9. MRG_MYISAM

N

  1. NATURAL
  2. NOT
  3. NULL
  4. NUMERIC

O

  1. ON
  2. OPTIMISE
  3. OPTION
  4. OPTIONALLY
  5. OR
  6. ORDER
  7. OUTER
  8. OUTFILE

P

  1. PRECISION
  2. PRIMARY
  3. PRIVILEGES
  4. PROCEDURE
  5. PURGE

R

  1. READ
  2. REAL
  3. REFERENCES
  4. REGEXP
  5. RENAME
  6. REPLACE
  7. REQUIRE
  8. RESTRICT
  9. RETURNS
  10. REVOKE
  11. RIGHT
  12. RLIKE
  13. RTREE

S

  1. SELECT
  2. SET
  3. SHOW
  4. SMALLINT
  5. SOME
  6. SONAME
  7. SPATIAL
  8. SQL_BIG_RESULT
  9. SQL_CALC_FOUND_ROWS
  10. SQL_SMALL_RESULT
  11. SSL
  12. STARTING
  13. STRAIGHT_JOIN
  14. STRIPED

T

  1. TABLE
  2. TABLES
  3. TERMINATED
  4. THEN
  5. TINYBLOB
  6. TINYINT
  7. TRAILING
  8. TRUE
  9. TYPES

U

  1. UNION
  2. UNIQUE
  3. UNLOCK
  4. UNSIGNED
  5. UPDATE
  6. USAGE
  7. USE
  8. USER_RESOURCES
  9. USING

V

  1. VALUES
  2. VARBINARY
  3. VARCHAR
  4. VARCHARACTER
  5. VARYING

W

  1. WARNINGS
  2. WHEN
  3. WHERE
  4. WITH
  5. WRITE

X

  1. XOR

Y

  1. YEAR_MONTH

Z

  1. ZEROFILL
advertise here