This article mainly tells you how to differentiate the case sensitivity of MySQL in Linux. If you are interested in the steps to correctly differentiate the MySQL size in Linux, you can get a deeper understanding of it through the following articles.
1. After MySQL is installed in Linux, the default value is: case-sensitive for table names, not case-sensitive for column names;
2. log on to the/etc/my. add lower_case_table_names = 1 after [MySQLd] In cnf and restart the MySQL service. The setting is successful: The table name is case-insensitive;
Lower_case_table_names parameters:
- Lower_case_table_names = 0
0: Case Sensitive, 1: case insensitive
In Linux, the database name, table name, column name, And alias are case-sensitive:
1. The database name and table name are case sensitive;
2. Table aliases are case sensitive;
3. The column name and column alias are case-insensitive in all cases;
4. Variable names are case sensitive;
MySQL is case insensitive in Windows.
The above content is a description of MySQL Case sensitivity in Linux. I hope it will help you in this regard.
Original article title: Case sensitivity of MySQL Databases in Linux
Connection: http://www.cnblogs.com/liuzhengdao/archive/2010/01/28/1658562.html