Case sensitivity of MySQL Databases in Linux

MySQL database case sensitivity often occurs in actual applications, causing a lot of inconvenience. The following article describes how to distinguish the case sensitivity of MySQL Databases in Linux, I hope it will help you in this regard.

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, MySQL database names, table names, column names, 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 an introduction to the Case sensitivity problem of MySQL Databases in Linux. I hope you will have some gains.

The above content describes the case sensitivity problem of MySQL Databases in Linux. I hope it will help you in this regard.

Edit recommendations]