Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial


MySQL - Identifiers

This article describes identifiers in MySQL.

Identifiers rules

MySQL - Identifier
First Character An alphanumeric character
Subsequent Characters Alphanumeric characters, the underscore (_), dollar sign ($)
Maximum Length 64 bytes

Alias names are limited to 255 bytes
Case Sensitivity Identifiers are not case sensitive for MySQL on Windows, and case sensitive for MySQL on Unix.
Trigger names are case sensitive not depending on the platform
Standards ANSI SQL - $ is not allowed

Identifiers - Differences between MySQL and other Databases

Database Identifiers First Character Subsequent Characters Max Length
Oracle Oracle Identifiers Not allowed: digit Allowed: # 30
SQL Server SQL Server Identifiers Not allowed: digit
Allowed: _, @ and #
Allowed: # and @ 128
IBM DB2 IBM DB2 Identifiers Not allowed: digit Not allowed: $ 128
PostgreSQL PostgreSQL Identifiers Not allowed: digit
Allowed: _
No differences 63
Sybase ASE Sybase ASE Identifiers Not allowed: digit
Allowed: _ , @ and #
Allowed: # and @ 255
Sybase ASA Sybase ASA Identifiers Not allowed: digit
Allowed: _ , $, @ and #
Allowed: # and @ 128
Informix Informix Identifiers Not allowed: digit
Allowed: _
No differences 128
Teradata Teradata Identifiers Not allowed: digit
Allowed: _, $ and #
Allowed: # 30
HP Neoview HP Neoview Identifiers Not allowed: digit Not allowed: $ 128
Interbase/Firebird Interbase/Firebird Identifiers Not allowed: digit No differences 67

Quoted or Delimited Identifiers

MySQL - Quoted Identifiers
Quotation Marks Back tick (``)
Characters Any character except ASCII 0(0x00) or a byte with the value of 255 and the space in the end of database, table and column names
Maximum Length 64 bytes not including quotes
Case Sensitivity Case sensitive
Notes When ANSI_QUOTES SQL mode is enabled it is also allowed to use double quotes (“”) to quote identifiers.

Quoted Identifiers - Differences between MySQL and other Databases

Database Identifiers Quotation Marks Characters Case Sensitivity
Oracle Oracle Quoted Identifiers “” Any except quotes Case sensitive
SQL Server SQL Server Quoted Identifiers [] and “” Any except quotes Case insensitive
IBM DB2 IBM DB2 Quoted Identifiers “” Any including quotes Case sensitive
PostgreSQL PostgreSQL Quoted Identifiers “” Any including quotes Case sensitive
Sybase ASE Sybase ASE Quoted Identifiers [] and “” Any except pound sign (#) as the first character Case insensitive
Sybase ASA Sybase ASA Quoted Identifiers [] and “” Any Case insensitive
Informix Informix Quoted Identifiers “” Any including quotes Case sensitive
Teradata Teradata Quoted Identifiers “” Any including quotes Case insensitive
HP Neoview HP Neoview Quoted Identifiers “” Any except at sign (@), forward slash (/),
circumflex character (^) as the first character
and space(s) as the last character(s)
Case sensitive
Interbase/Firebird Interbase/Firebird Quoted Identifiers “” Any character except space(s) as the last character(s) Case sensitive

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.