Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners

Code Factory for MySQL online Help

  Return to chapter overview  

MySQL identifiers

There are some restrictions on the characters that may appear in identifiers:

No identifier can contain ASCII 0 (0x00) or a byte with a value of 255.

 

The use of identifier quote characters in identifiers is permitted, although it is best to avoid doing so if possible.

 

Database, table, and column names should not end with space characters.

 

Before MySQL 5.1.6, database names cannot contain ‘/’, ‘\’, ‘.’, or characters that are not allowed in a directory name.

 

Before MySQL 5.1.6, table names cannot contain ‘/’, ‘\’, ‘.’, or characters that are not allowed in a filename.

 



  Return to chapter overview