Is MySQL Case Sensitive?

In this quick tutorial, we will answer the question "Is MySQL Case Sensitive?".

MySQL's case sensitivity can be affected by a number of variables, such as the type of token being used and the system's operating system. MySQL's case sensitivity data is displayed in the below table:

Token TypeCase Sensitivity
KeywordsCase Sensitive
Identifiers (Databases and Tables)Depending on the operating system's case sensitivity settings. On all Unix platforms besides Mac OS X with the HFS+ file system, database and table names are case-sensitive. On Mac OS X utilizing HFS+ and Windows, case-sensitivity applies.
Tables AliasesCase Sensitive
Column AliasesCase Sensitive
MySQL Case Sensitivity

This tutorial explained how is MySQL case-sensitive works.