In Linux, Mysql is case sensitive.

In Linux, Mysql is case-sensitive. 1. After mysql is installed in Linux, It is the default value: case-sensitive for table names, not case-sensitive for column names. 2. After logging on with the root account, in/etc/my. add "lower_case_table_names = 1" after [mysqld] In cnf and restart the MYSQL service. The settings are successful: Case Insensitive to table names; lower_case_table_names parameter description: lower_case_table_names = 0 0: case-sensitive, 1: case-insensitive www.2cto.com MySQL in Linux Database Name, table name, column name, alias case-sensitive rules are as follows: 1. The database name and table name are case sensitive. 2. The table alias is case sensitive; 3. column names and column aliases are case-insensitive in all cases; 4. Variable names are case-sensitive; MySQL is case-insensitive in Windows.