MySQL supports table name capitalization under Windows, Lower_case_table_names

Original: MySQL supports table name capitalization under Windows, Lower_case_table_names

MySQL By default in Windows is not the case of table name, that is, table name casing is not sensitive.

Camel-style table names created with phpMyAdmin are all forced to lowercase.

MySQL table name case sensitive parameter: lower_case_table_names.

C:\ProgramData\MySQL\MySQL Server 5.6\my.ini file under Windows2012

Add lower_case_table_names=0 under [mysqld] (restart MySQL Service required).

###

[Mysqld]

Lower_case_table_names=0

###

The default value for Win is 1, which means that MySQL will actively lower the table name.

Lower_case_tables_names

0: Default value, case sensitive;
Note that if you force the--lower-case-table-names=0 to 0 on a case-insensitive file system and access the MyISAM table name with a different casing, the index corruption will occur.
1: The table name is saved in lowercase on the hard disk, and the name is not case sensitive. MySQL converts all table names to lowercase to store and find
2: The table name and database name are saved on the hard disk using the case specified by the CREATE TABLE or CREATE DATABASE statement, but MySQL converts them to lowercase for lookup.

MySQL supports table name capitalization under Windows, Lower_case_table_names