[adsense id=”0514458240″ width=”468″ height=”60″]
I have included a list of all the reserved words in MySQL release 5.1. If you are attempting to create a table with any of the following reserved words (either uppercase or lowercase) with escaping them first then you will get an error:
[nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'reserved word ...' at line 1]
| 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 |
| NO_WRITE_TO_BINLOG |
| NOT |
| NULL |
| NUMERIC |
| ON |
| OPTIMIZE |
| OPTION |
| OPTIONALLY |
| OR |
| ORDER |
| OUT |
| OUTER |
| OUTFILE |
| PRECISION |
| PRIMARY |
| PROCEDURE |
| PURGE |
| RANGE |
| READ |
| READ_WRITE |
| READS |
| 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 |
| SQL_BIG_RESULT |
| SQL_CALC_FOUND_ROWS |
| SQL_SMALL_RESULT |
| SQLEXCEPTION |
| SQLSTATE |
| SQLWARNING |
| 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 |