MySQL Case sensitive issues

In MySQL, databases and tables are actually directories and texts under the data directory.

Thus, the sensitivity of the operating system determines the case sensitivity of database and table naming. This means that the database and table names are case insensitive in Windows, and are case-sensitive in most types of unix/linux systems.

MySQL case sensitivity can be controlled by the Lower_case_table_names parameter of the configuration file.

Windows:

Edit the My.ini file under the MySQL installation directory, add lower_case_table_names=0 under the [Mysqld] section (note: Case sensitive for 0 o'clock, not sensitive for 1 o'clock case, default is 1), You can implement MySQL to define table names according to the case state of the SQL statement that was built.

Linux:

Edit the/etc/my.cnf file, add the Lower_case_table_names parameter under the [Mysqld] section, and set the appropriate value (note: 0 o'clock case sensitive, 1 o'clock case insensitive, default = 0)

MySQL Case sensitive issues