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 Type||Case Sensitivity|
|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 Aliases||Case Sensitive|
|Column Aliases||Case Sensitive|
This tutorial explained how is MySQL case-sensitive works.