MySQL table name, column name, case-sensitive detailed

Introduction: Issues that occur on the local database execution of modifications the bank card is not error-free but online execution error

found that the table is not found, the table name should be card_cardinfo, but there is no problem locally, can be modified, and then tested in the database, found that the local library (win) Table name is not case-sensitive, online (Linux) differentiated

When I first started using MySQL, I started out by trying to distinguish between the case of a column name and a lot of things on the internet, so I just
1, Linux under the installation of MySQL is the default: distinguish the case of the table name, do not distinguish between the case of the column name;
2, 2, with the root account login, in the/ETC/MY.CNF [mysqld] After adding add Lower_case_table_names=1,
Restart the MySQL service, the success is set: The case of the table name is not distinguished; The Lower_case_table_names parameter is detailed:
Lower_case_table_names = 0
Where 0: Case sensitive, 1: Case insensitive
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 column alias in all cases are ignored case, 4, variable name is also strictly case-sensitive;
MySQL is case insensitive under Windows.
Add Lower_case_table_names=1 after [mysqld] in My.ini, restart the MySQL service, this time has been set successfully: The case of the table name is not distinguished; Lower_case_table_names parameter details:
Lower_case_table_names = 0
Where 0: Case sensitive, 1: Case insensitive
3, if you want to distinguish the case of the field value when querying, then: The field value needs to set the binary property, there are several ways to set it:

A. Set at creation time: Create TABLE T (
A VARCHAR (Ten) BINARY);
B. Modify with Alter:
ALTER TABLE ' tablename ' MODIFY COLUMN ' cloname ' VARCHAR BINARY; C, the MySQL table editor directly tick binary items.
Garbled solution, more detailed look at the character set this article

MySQL table name, column name, case-sensitive detailed