1and1 Help Centre Categories

print article

New Reserved Words for MySQL 5.5

For 1&1 Linux Hosting and Managed Servers

Learn how to adjust your MySQL queries for migration from MySQL 5.1 to MySQL 5.5.

It is no longer possible to create MySQL 5.1 databases. Every new MySQL database created in the 1&1 Control Panel will use MySQL 5.5. This is to ensure optimal compatibility with script applications based on PHP 5.6.

In some cases, migrating your MySQL 5.1 database to a MySQL 5.5 database may result in some errors. This is because MySQL 5.5 has addtional keywords and reserved words which MySQL will recognize as part of the SQL language, rather than as an identifier (i.e. a table name, database name, etc). If a table name, database name or any other identifier matches one of the reserved words below, it will cause an error in the execution.

New Keywords and Reserved Words for MySQL 5.5
CATALOG_NAME CLASS_ORIGIN COLUMN_NAME CONSTRAINT_CATALOG
CONSTRAINT_NAME CONSTRAINT_SCHEMA CURSOR_NAME ERROR
GENERAL IGNORE_SERVER_IDS MASTER_HEARTBEAT_PERIOD MESSAGE_TEXT
MYSQL_ERRNO PROXY RELAY RELAYLOG
RESIGNAL SCHEMA_NAME SIGNAL SLOW
SUBCLASS_ORIGIN TABLE_NAME XML

In order to avoid errors, surround any identifiers that match the keywords or reserved words above in backticks as shown in the example below.

Incorrect MySQL 5.5 Statement
SELECT signal FROM table WHERE id=3;
Corrected MySQL 5.5 Statement
SELECT `signal` FROM table WHERE id=3;