Mysql reserved words

The following list shows the keywords and reserved words in MySQL 5. Reserved keywords are marked with (R). In addition, _FILENAME is reserved. At some point, you might upgrade to a higher version, so it is a good idea to have a look at future reserved words , too. Quoting of identifiers was introduced in MySQL Version 3. You can also enclose identifiers with double quotation marks () if you run MySQL in ANSI mode.

MySQL has some special names called reserved words. A reserved word can be used as an identifier for a table, column,. It is not uncommon to come across MySQL databases where reserved words are in use as identifiers for any kind of database objects. This chapter describes the data types used within Oracle.

It shows the MySQL data types and what is the Oracle equivelent. It also provides you with a list of reserved words within Oracle. The list below represents a combination of the following sources of SQL reserved words : List of SQL reserved words Develop guide on Drupal.