MySQL is case-insensitive under Windows, and the table name is automatically converted to lowercase when the script file is imported into MySQL, resulting in an error when you want to put the database export into use on a Linux server. Because the table names in Linux are case-sensitive and cannot find a table, many of them say that changing the MySQL settings under Linux makes it not case-sensitive, but there is no way to make Windows case-insensitive in turn. In fact the method is the same, the corresponding changes in the Windows MySQL settings on the line.
Specific operation:
Add a line to the MySQL configuration file My.ini:
Lower_case_table_names = 0
Where 0: Case sensitive, 1: not case sensitive
Note: Ensure that there is no duplicate configuration in the configuration file , after modifying the My.ini configuration file, you need to restart the MySQL service to take effect.
MySQL under Linux database name, table name, column name, alias casing rules are like this:
1, database name and table name are strictly case-sensitive;
2, the table alias is strictly case-sensitive;
3, the column name and the alias of the column in all cases are ignored case;
4, variable names are also strictly case-sensitive; MySQL is case-insensitive under Windows
MySQL table name capitalization issues under Windows and Linux