Recently, the new MySQL instance imported SQL data, found more than the old MySQL 100+ table, the final discovery is the MySQL table name case, the simple problem is delayed for a long time, in this record, in order to prevent the same mistake again;
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, with the root account login, in the/ETC/MY.CNF [mysqld] After adding add Lower_case_table_names=1, restart the MySQL service, this time has been set success: not distinguish between the case of the table name;
Lower_case_table_names parameter Details:
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 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.
This article is from the "Linux_ ant" blog, please make sure to keep this source http://onlyoulinux.blog.51cto.com/7941460/1608542
MySQL table name capitalization problem under Linux